I have a list of journal entries that is missing some detail (Table
A). IN Another table (Table B) I have the year's listing of journal
entries that contains this detail plus a lot more. What formula can I
write in table A that will find the associated record in B (say based
on journal number and dollar amount) that will bring across the
correct detail for each line.

They are both arranged in columns in a similar structure and contain
both text and numbers.

I know this but am having a brain fade!

Thanks