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!
Hi Julie
You could try using a VLOOKUP.
See if this helps.
Sunny
Thanks! Can I use vlookup with tables, so the automatically expands, has totals, etc.? Tyring to make this as automated as possible.
Hi Julie
Yes, you can add the total to the table.
You can read more about tables here : https://www.myonlinetraininghub.com/excel-2007-tables
Sunny
