Table Lookup?

[Roger Emerick]

I use Vlookup and Hlookup frequently. Sometimes I'd like
to look up a value in a table, where the first row and
first column contain the lookup values, which may not be
in alph numeric sorted order. I there a Table Lookup
function? I can't find one. Thanks - Roger

 

[Frank Kabel]

Hi Roger
have a look at
http://www.cpearson.com/excel/lookups.htm#DoubleLookup

for a 'double' lookup on rows and columns

HTH
Frank

 

[Jason Morin]

This often called a "double lookup." MVP Chip Pearson has
an examples on his site.

http://www.cpearson.com/excel/lookups.htm#DoubleLookup

This article gives 2 examples, one using a natural
language formula:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;275170&Product=xlw2K

HTH
Jason
Atlanta, GA

 

[Roger Emerick]

It works! This is great! Thanks Frank

-----Original Message-----
Hi Roger
have a look at
http://www.cpearson.com/excel/lookups.htm#DoubleLookup

for a 'double' lookup on rows and columns

HTH
Frank





.

 

[Frank Kabel]

Hi Roger
thanks for the thanks though I think they should go to Chip Pearson for
his excellent site
Frank

 

[Gord Dibben]

Roger

This may be what you are looking for.......

You have a table A1:J10

Say A1:A10 contains labels A through J and B1:J1 contains labels Q through Y

B2:J10 contains data.

One method is to select the entire table A1:J10 then choose
Insert>Name>Create, and select top row and left column.

Then use the intersect functionality:

=E W

This will return the value of the cell at the intersection of the row 5(E) and
column H(W)

Gord Dibben Excel MVP