View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlos R Carlos R is offline
external usenet poster
 
Posts: 1
Default Lookup a value that fits two (2) criterion

I need to find a value that is identified by 2 criterion. For example, I need
to identify the profit of brand y in store 91 (7.0). A vlookup only considers
one criterion, so I need to crossreference with another.

Store Brand Sales Profit Index
91 x 12.6 6.5 0.9
91 y 11.3 7.0 0.7
91 z 19.4 8.3 1
33 x 11.3 7.1 0.6
33 y 10.0 7.0 0.9
33 z 14.0 7.3 0.8

Thank you for your help