LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Multi Part Lookup


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi column lookup Cain Excel Discussion (Misc queries) 0 April 17th 08 10:01 AM
Lookup multi criteria oscarcounts Excel Worksheet Functions 7 March 11th 08 06:22 PM
Find last name in multi-part name? Eric Excel Worksheet Functions 4 November 1st 07 04:51 PM
lookup multi values robtlewis957 Excel Worksheet Functions 2 August 25th 06 03:26 AM
Multi Criteria lookup epotter Excel Discussion (Misc queries) 3 July 6th 06 12:32 AM


All times are GMT +1. The time now is 06:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"