Is there a way to have a VLOOKUP function look up a value in 2 columns
instead of 1 column?
Lookup_Value = looking up 1 cell that has a number in it. (Got that part)
Table_Array = Selected my area in my worksheet - ex:
01 topo table 30
02 topo model 31 reception desk
Col_index_num = This is where I would like it to look at both 2nd and 4th
column information. See above - If i enter a 01 or 02 - I get the correct
answer but if I enter a 31 I get a 0. I need a VLOOKUP mixed with a little
HLOOKUP.
Range_lookup = TRUE

Is this possible?