View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeD1224 MikeD1224 is offline
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.