I have 6 tabs full of test data
The test data on each tab is in the A5:DU150 cell range
but the test data is not in the same order on each tab
I'd like to search for the string I've entered in column A on the master tab (ie "G-1") on the other tabs and then put the date that is 2 columns to the right of the string on my master sheet and if there isn't a date put the word open.
Example Master (idea of what it will look like when complete)
Test pt date1 date2 date3 date4 date5 date6
G-1 1/1/12 2/1/12 4/1/12 3/3/12 open 9/4/12
...
G-720
tab1 might have G-1 in A5 with the date in C5
but tab2 might have G-1 in DP30 with the date in DR30
& tab3 might have G-1 in AJ50 with the date in AL50
If the G-1 were in the same cell in each tab it would be easy but they aren't
I've tried using MATCH & LOOKUP to find the cell that contains G-1 but I keep getting errors.
I know there has to be a simple way to do this.
Thanks for any help/direction
Bookmarks