Vlookup in another worksheet

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

08-10-2017, 06:14 AM

NBVC

Windows 10 Vlookup in another worksheet

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Ok.

Try this formula in E3 of each sheet, copied down:

=IFERROR(INDEX(OUT[REF. NO.],MATCH(B3,OUT[INCOMING REF. NO.],0)),"")

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 02:32 PM.