Looking up two values

  • Thread starter Dumbfounded in Denver
  • Start date
D

Dumbfounded in Denver

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting Lookup Functions 4
use Hlookup to look up two or more values 5
Hlookup with Merged cell as look up value 1
Combining Hlookup and vlookup 6
Look up one value and return multiple corresponding values 2
Help with HLOOKUP/INDEX/MATCH 6
look ups 4
Large Data File Consolidation... 2

Top