Register
Log In
Unanswered
Home
New Member
August 31, 2017
Offline
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!
Dashboards
June 25, 2016
Offline
Hi Julie
You could try using a VLOOKUP.
See if this helps.
Sunny
New Member
August 31, 2017
Offline
Thanks! Can I use vlookup with tables, so the automatically expands, has totals, etc.? Tyring to make this as automated as possible.
Dashboards
June 25, 2016
Offline
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
Most Users Ever Online: 57
Currently Online:
13 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
