VLOOKUP using NEGATIVE column ref #?

[DMP3]

I am trying to look up a value in a table that is found in a column that is LEFT of the referenced table but as we all know this does not work and returns #N/A.
=VLOOKUP(D3,'sheet2'!B:M,-12,FALSE)
So in other words I want to look up the value in D3 (which = text "ITU") in a table found in sheet 2 and that value (ITU) would be found in column M of sheet 2. Then I want it to return the corresponding value found in column B of sheet 2 in the row of the column where "ITU" is found (column M of sheet 2).
Hope I explained that well... thanks for your help

 

[VoG]

Try

=INDEX(Sheet2!B:B,MATCH(D3,Sheet2!M:M,0))

 

[Jonmo1]

Welcome to the board...

Yep, Vlookup is Zoolander Challenged. It can't turn left...

You have to use Index/Match

Try

=INDEX('Sheet2'!B:B,MATCH(D3,'Sheet2'!$M:$M,0))

Hope that helps.

 

[DMP3]

Thank you very much Mr. MVP! That worked.