New Member
August 31, 2017
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!
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Hi Julie
Yes, you can add the total to the table.
You can read more about tables here : https://www.myonlinetraininghu.....007-tables
Sunny
1 Guest(s)