Lookup Formula - Table Array

[WILDFLOWER92]

I am using a lookup formula and am referencing a cell for the table array; however the cell reference is a word. I think I have to convert the cell reference to a different format like tex() or value() but I cant remember.

Example Formula:VLOOKUP(CONCATENATE(C5,LEFT(B16,3)),C3,4,FALSE)

C3 Cell = India

Please help.

 

[barry houdini]

Assuming India is a named range with at least 4 columns try using INDIRECT like this

VLOOKUP(C5&LEFT(B16,3),INDIRECT(C3),4,0)

 

[WILDFLOWER92]

Thank you, exactly what I was looking for!