Looking up value in left column

  • Thread starter Thread starter noah
  • Start date Start date
N

noah

I need to use a lookup function to find a value in a column to the lef
of my lookup vector.
Sheet1:
Lookup B1 from Sheet2 D1:D100 and return result from Sheet2 A1:A100, o
return FALSE.
I can't get a vlookup or lookup to work. And I can't move Column A o
Sheet2 to the right of Column D.
Is this possible at all
 
C1:

=MATCH(B1,Sheet2!$D$1:$D$100,0)

D1:

=IF(ISNUMBER(C1),INDEX(Sheet2!$A$1:$A$100,C1))

D1 is the result cell.
 
Thanks. It works. But do you think there is a way to input that into on
function in one column instead of using both C1 and D1
 
Back
Top