| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Movng Data Automatically the Fits a provision | Excel Worksheet Functions | |||
| How do I list all Data in a column that fits between two points? | Excel Discussion (Misc queries) | |||
| I would like a function to return a value that fits its range | Excel Worksheet Functions | |||
| nonlinear regression/ curve fits | Excel Discussion (Misc queries) | |||
| Making an alphabetical list that fits on one page. | New Users to Excel | |||
Threaded Mode
