monkey_kebab
New Member
- Joined
- Apr 21, 2006
- Messages
- 10
Howdy -
I have a report which pulls data from multiple worksheets (all contained within the same spreadsheet file). Because the raw data comes from multiple databases we use the following formulas to verify the individuals from one source are included in the results from the other:
=VLOOKUP(C2,’C’!A:B,2,FALSE)
=VLOOKUP(C2,’D’!A:B,2,FALSE)
One formula looks up the individual’s unique ID in column ‘C’ and compares it against a list in column ‘A’ of worksheet ‘C’. If it finds a match it displays the corresponding text in column ‘B’ of worksheet ‘C’ (the word ‘Reconciled’)… ‘#N/A’ is displayed if no match is found.
The second formula does the same thing except it runs in the next column over & looks through a list on worksheet ‘D’.
We are forced to split the data from one source between worksheets 'C' & 'D' because it comprises more than 65,000 rows of information.
What I’m wondering is it’s possible to modify the formula so we can have it do the lookup of both worksheets from one cell. Right now we have two columns of results, with ‘Reconciled’ and ‘#N/A’ displayed in one or the other for each individual. We want to be able to identify those who do not show up in either list (right now they show up with ‘#N/A’ results in both of these columns).
Thanks,
Bob T.
I have a report which pulls data from multiple worksheets (all contained within the same spreadsheet file). Because the raw data comes from multiple databases we use the following formulas to verify the individuals from one source are included in the results from the other:
=VLOOKUP(C2,’C’!A:B,2,FALSE)
=VLOOKUP(C2,’D’!A:B,2,FALSE)
One formula looks up the individual’s unique ID in column ‘C’ and compares it against a list in column ‘A’ of worksheet ‘C’. If it finds a match it displays the corresponding text in column ‘B’ of worksheet ‘C’ (the word ‘Reconciled’)… ‘#N/A’ is displayed if no match is found.
The second formula does the same thing except it runs in the next column over & looks through a list on worksheet ‘D’.
We are forced to split the data from one source between worksheets 'C' & 'D' because it comprises more than 65,000 rows of information.
What I’m wondering is it’s possible to modify the formula so we can have it do the lookup of both worksheets from one cell. Right now we have two columns of results, with ‘Reconciled’ and ‘#N/A’ displayed in one or the other for each individual. We want to be able to identify those who do not show up in either list (right now they show up with ‘#N/A’ results in both of these columns).
Thanks,
Bob T.