View Single Post
  #1   Report Post  
Dumbfounded in Denver
 
Posts: n/a
Default Looking up two values

I have a spreadsheet that needs to look up a numerical value first and then
go to the month that we are closing e.g. February and apply the value in the
cell that is on the row first looked up. I have tried to do a vlookup nested
with an hlookup but can not get the formula right to make it work for
anything other than January data. Thanks for your help.