| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple match statements?
Hi,
I am trying to match 3 data points and return the value for the cell they intersect at - without using concatenate if possible. In the below table I would like to return the value for Product A, Country UK, Week 2 i.e. 20 - any ideas? Product Country Week Qty A UK 1 10 A UK 2 20 A UK 3 15 A FR 1 10 A FR 2 12 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements? | Excel Worksheet Functions | |||
| match statements | Excel Discussion (Misc queries) | |||
| Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
| Match/Lookup Statements | Excel Worksheet Functions | |||
| Data Validation w/ If, Match & Index Statements | Excel Worksheet Functions | |||
Threaded Mode
