combining vlookup and hlookup functions
 

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.
--
Adrienne

combining vlookup and hlookup functions
 

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

"Adrienne" wrote:

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.
--
Adrienne

combining vlookup and hlookup functions
 

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),MAT CH(K1,Sheet3!A1:H1,0))

Mike

Mike

"Mike H" wrote:

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

"Adrienne" wrote:

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.
--
Adrienne