Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Store # Jan Feb Mar 1 471,374 488,292 3 - - 4 488,295 470,050 5 122,927 113,160 I have the data above and need to do a 2 part lookup. I need to do a lookup on store 1 and then do a lookup on Jan to return the value (471,374). I need to do this for each store, for each month of the year. I am trying to only write 1 formula that will first match the correct store and then do an hlookup on the appropriate month. I need help. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multi column lookup | Excel Discussion (Misc queries) | |||
Lookup multi criteria | Excel Worksheet Functions | |||
Find last name in multi-part name? | Excel Worksheet Functions | |||
lookup multi values | Excel Worksheet Functions | |||
Multi Criteria lookup | Excel Discussion (Misc queries) |