Vlookup in another worksheet

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup in another worksheet

FAQ

Thread Tools

Display Modes

08-10-2017, 05:02 AM

NBVC

Windows 10 Vlookup in another worksheet

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:13 AM.