Looking up value in left column

[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 D1100 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

 

[Aladin Akyurek]

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.

 

[noah]

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