View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adrienne Adrienne is offline
external usenet poster
 
Posts: 7
Default 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