V lookup and H lookup together

[Sissy]

Is it possible to do a v lookup and an h lookup at the same time? For
example I want to find the data that matches the row and column of the cell
I'm in?

 

[vezerid]

=INDEX(data,rownumber,colnumber)

data is a 2D array. row- and colnumber are either supplied as
constants or are computed by MATCH, if you need to locate row and
column by looking up.

HTH
Kostis Vezerides

 

[Niek Otten]

Hi Sissy,

Let's say your Horizontal keys are in B1:E1 and your Vertical keys in A2:A5. So your data is in B2:E5

Your Formula:

=INDEX(B2:E5;MATCH(H1;A2:A5;0);MATCH(G1;B1:E1;0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is it possible to do a v lookup and an h lookup at the same time? For
| example I want to find the data that matches the row and column of the cell
| I'm in?

 

[Sissy]

Hi Niek,
Thank you, I'm trying this, but what's H1 and G1 in your formula? Where
does it reference the other spreadsheet I'm trying to get data from? Say
this is the sheet that contains data:
01/01/2007 02/01/2007 02/14/2007 02/20/2007
Blue Shirts 1000 1200 1100 1300
Blue Pants 50 75 60 65
Red Shirts 500 700 400 300
Red Pants 20 25 15 10

And I want to fill in this spreadsheet in the appropriate places based on
the description and date:

01/01/2007 01/15/2007 02/01/2007 02/15/2007
Red Pants
Blue Pants
Red Shirts
Blue Shirts

Thank you! -Sissy