combining vlookup and hlookup functions

  • Thread starter Thread starter Adrienne
  • Start date Start date
A

Adrienne

I have a table with years across the top and months in the first column.
Within the table is data for each month of each year. Is there a way I can
point to a cell on another sheet with a particular year and another cell with
a particular month and return the number at the intersection of the
month/year matrix on the first sheet?

Thanks for any help.
 
Hi,

Try the formula below. It assumes your full table is in A1 - H13 and the 2
lookup values (Month) in J1 and (Year) K1

=INDEX(A1:H13,MATCH(J1,A1:A13,0),MATCH(K1,A1:H1,0))

Mike
 
Hi,

I missed the 'other sheet bit' try this which assumes your table is on
sheet3 and your lookup values are on the same sheet as the formula.

=INDEX(Sheet3!A1:H13,MATCH(J1,Sheet3!A1:A13,0),MATCH(K1,Sheet3!A1:H1,0))

Mike

Mike
 
Back
Top