View Single Post
 
Old 02-20-2018, 05:32 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

It's because you can't use the Vlookup to look backwards.

From the Excel help:

Quote:
Looks in the first column of an array and moves across the row to return the value of a cell
Try this instead...

=IFERROR(INDEX('Data Sheet'!B:B,MATCH(B3,'Data Sheet'!C:C,0)),"")
Reply With Quote