| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple crieria searches
I am looking to have a returned cost based on 3 criterias
1. job location (cell F1) 2. Mix type (cell F2) 3. Plant (cell F3) I have it set up in a table format.... Job Loc. Mix type Plant Cost A1 B1 C1 D1 1 L 12.5 3 $12.00 2 L 9.5 2 $5.00 3 M 12.5 1 $8.00 F1= L F2=12.5 F3= 3 returns D1 I hope this makes sense...... Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple crieria searches
I think I am following but not positive. If you have 2007 why not just use a
SUMIFS? "Eric" wrote: I am looking to have a returned cost based on 3 criterias 1. job location (cell F1) 2. Mix type (cell F2) 3. Plant (cell F3) I have it set up in a table format.... Job Loc. Mix type Plant Cost A1 B1 C1 D1 1 L 12.5 3 $12.00 2 L 9.5 2 $5.00 3 M 12.5 1 $8.00 F1= L F2=12.5 F3= 3 returns D1 I hope this makes sense...... Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup for multiple searches | Excel Discussion (Misc queries) | |||
| Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
| help with vlookup, wildcards, multiple searches | Excel Worksheet Functions | |||
| multiple searches? | Excel Worksheet Functions | |||
| When using SUMIF won't worj with crieria = cell referrence | Excel Worksheet Functions | |||
Linear Mode
