Can the info in the field of a non related record in another table be shown in a field?

I have a table that holds information that an automation setup by someone else puts info into a record when it's created.  The records aren't related when this happens, it just pulls data initially into a Note field.  Is there a formula that can retrieve some other info I need from another field?  I would use an If statement to let it know which info to pull, but I'm wondering if there is a formula to tell it which record and field to get the info from.

In other words, a formula that says, go to a specific field in a specific record in a specific table  and display the content.

The tables do have a relationship, but the records aren't related when the automation already in place creates the record.  Hope that makes sense.

Thanks,

Dana