|
|
|
|
#1
08-10-2017, 05:02 AM
|
||||
|
||||
First create a list of all your sheets somewhere in the Master List (you can hide the column afterwards)....
So, assuming you created this list in Master List!P2:P6, enter formula in Master List, C2: =IF(F3="","",VLOOKUP(F3, INDIRECT("'"&INDEX($P$2:$P$6, MATCH(TRUE, COUNTIF(INDIRECT("'"&$P$2:$P$6&"'!$B$3:$B$17"),F3) >0,0))&"'!$B$3:$C$17"),2,0)) confirm with CTRL+SHIFT+ENTER not just ENTER. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| worksheet compatibility issues using VLOOKUP | gringodegolfo | Excel | 6 | 03-23-2016 08:23 PM |
 Appending unique data from one worksheet to existing data on another worksheet
|
EdStockton | Excel | 1 | 08-06-2014 11:00 PM |
|
How to summarise different worksheet to a summary worksheet
|
samkiewhock | Excel | 1 | 09-06-2012 03:34 AM |
|
"Auto-populating" data-worksheet to worksheet.
|
meggenm | Excel | 4 | 02-04-2012 02:04 AM |
| Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
Windows 10 
Office 2013
Hybrid Mode