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
=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