WILDFLOWER92
New Member
- Joined
- May 31, 2002
- Messages
- 14
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.
Example Formula:VLOOKUP(CONCATENATE(C5,LEFT(B16,3)),C3,4,FALSE)
C3 Cell = India
Please help.