Match IDs in Tables|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I am exporting donor information from Flicause once a month. Donors have an ID in Flicause. I then need to match those donor IDs with the accounting software, Logos, where they have a different ID.

Flicause ---->  Logos (accounting software)

Mr. A #234-------> Mr. A #456

I would like to use tables (so it expands, totals, etc.) but not sure how I would go about that.

I have a function, but that means updating the formula....=TwoD(P2, CrossRef!$A$7:$A$18, 1)

Crossref table has a column for Flicause and adjacent column tells what # they are in Logos.

Can I write a formula that would reference the Crossref table using structured formulas, that would return the Logos number in the flicause table?  I tried replacing the values in the function, but I don't know enough to make it work. 

Thoughts?

Thanks so much!