View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dale Dale is offline
external usenet poster
 
Posts: 92
Default Combining Hlookup and vlookup

I am trying to use the vlookup and hlookup to "cross hair" a cell. I have
used this combination before but I cannot remember the formula. I have items
in the first column and a month identifier in the following columns. So I am
trying to look up Beans in column A with the production in columns that have
months listed in them, i.e. column B is January, column c is February, etc.

Thanks

Dale