i have a workbook, with 10 sheets, named 'sheet1, sheet2' etc...
and another 3 sheets and a summary sheet.
in the summary sheet are a list of record ID's, and within the 10 sheets i have a bunch of record ID's with corresponding values I want to lookup.
How do I do this so it searches across all 10 worksheets?
First create a list of all your sheetnames in a column somewhere on your summary sheet.
Name this list "TabNames" - without quotes (through, Insert|Name|Define)
Then use a formula such as:
Where A1 is the lookup item in your summary sheet.
Please Login or Register to view this content.
and A1:B100 is the lookup table in the detail sheets
Note: After you adjust the ranges in the formula to suit your data you must confirm it with CTRL+SHIFT+ENTER not just ENTER.. you will see { } brackets appear around the formula...
Then you can copy it down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks