Excel Vlookup Not Returning Correct Information
Hi Criss,
Am Sun, 11 Oct 2015 03:07:34 +0100 schrieb smim:
|Filename: sheet1.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1018|
|Filename: sheet2.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1019|
VLOOKUP looks from left to the right. You are looking in column B and
want an output from column A. You have to use a INDEX/MATCH combination:
=IFERROR(INDEX(Data2!A:A,MATCH(A2,Data2!$B$1:$B$20 0,0)),"")
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|