looking up values from a table

[Dan Winterton]

I'm familiar with vlookup and hlookup functions. Is there
some kind of function to look up values in a table using
both a horizontal and vertical reference simultaneously?
Ex: I have a table with 1,2,3,4,5,6 in the vertical head
column and a,b,c,d,e,f along the horizontal head row with
values filling the table. I want to look up the value in
the cell that is intersected by 5 and C.

 

[JulieD]

Hi Dan

a combination of INDEX and MATCH should give you what you're after
=INDEX(A1:G7,MATCH(5,A1:A7,0),MATCH("c",A1:G1,0))

will look for 5 in the range A1:A7 and C in the range A1:G1 and return the
value at the intersection.

Hope this helps
Cheers
JulieD

 

[Alan Beban]

I'm familiar with vlookup and hlookup functions. Is there
some kind of function to look up values in a table using
both a horizontal and vertical reference simultaneously?
Ex: I have a table with 1,2,3,4,5,6 in the vertical head
column and a,b,c,d,e,f along the horizontal head row with
values filling the table. I want to look up the value in
the cell that is intersected by 5 and C.

If you used headers that are available as valid range names (e.g., not
numbers and not c), you could use the Intersection Operator.

Alan Beban