I have a scenario that I cannot figure out:
In the cells below I have 4 different scenarios that might be. The results will either be Part 9, 10, 11, 12.
How would you write a formula that looks at What the combination of values in Group 1 and 2 are to return the correct results which would be Part 9, 10, 11, 12.
The values entered would be below and the certain order of the Parts would return the correct part for that combination of parts.
For example if Part 1 was in Cell A9 an Part 3 was in B9, how would I return Part 9 as the correct result in C9.
In the cells below I have 4 different scenarios that might be. The results will either be Part 9, 10, 11, 12.
How would you write a formula that looks at What the combination of values in Group 1 and 2 are to return the correct results which would be Part 9, 10, 11, 12.
The values entered would be below and the certain order of the Parts would return the correct part for that combination of parts.
For example if Part 1 was in Cell A9 an Part 3 was in B9, how would I return Part 9 as the correct result in C9.
| Book1 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Group 1 | Group 2 | Combined Part | ||
| 2 | Part 1 | Part 3 | Part 9 | ||
| 3 | Part 2 | Part 3 | Part 10 | ||
| 4 | Part 1 | Part 4 | Part 11 | ||
| 5 | Part 2 | Part 4 | Part 12 | ||
| 6 | |||||
| 7 | |||||
| 8 | |||||
| 9 | Part 1 | Part 4 | Correct results would return Part 9 for this combination | ||
Sheet1 | |||||
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| A9 | List | =$A$2:$A$3 |
| B9 | List | =$B$3:$B$4 |
Last edited:
