'
'Cell Formula using the OFFSET worksheet formula with multiple criteria to
' find a value in the same way that the VLOOKUP worksheet formula
' uses a single criteria to find a value.
'
'
'================================================= ===
'Forumla Example 1:
'Using actual values as the search criteria in EXAMPLE 1:
'{=OFFSET(E11,MAX(ROW(1:6)*--(B12:B17="John")*--(C12:C17="Nov")),0)}
' or
'Forumla Example 2:
'Using cell references as the search criteria in EXAMPLE 1:
'{=OFFSET(E11,MAX(ROW(1:6)*--(B12:B17=A6)*--(C12:C17=A7)),0)}
'
' - Remember to use CTRL-SHIFT-ENTER to make the formula an array
' showing the '{' and "}" at the beginning and ending of the formula
'
'Note: Just as VLOOKUP will give you the FIRST value it finds that meets it's
' criteria, this formul will give you the LAST value it finds that meets
' all of it's criteria.
'
'================================================= ===
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Tara Stokes" wrote:

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?