| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested VLOOKUP
I have to search and put values in one of my sheets after looking in
a field of a field. I believe i need to to a nested vlookup, but im not sure how to go about it. I copied the relevant portions of the data below: Department PriceType Monthly Average NY NY Average $1,000.00 NJ NJ NJ NJ Average $1,500.35 I have to search within a department (for example NJ), and then search where average is occuring in the Price Type field, and then pick the corresponding Monthly average value(1500.35 in this case) and put it in the vlookup formula origination sheet. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with nested IF | Excel Discussion (Misc queries) | |||
| Can Someone Help me With a Nested VLOOKUP | Excel Discussion (Misc queries) | |||
| Nested vlookup | Excel Discussion (Misc queries) | |||
| nested ifs or vlookup or ? | Excel Discussion (Misc queries) | |||
| Nested vlookup? | Excel Worksheet Functions | |||
Threaded Mode
