Output category based on multiple inputs

Question

I have 8 combinations o triplets, each with a name attached to them. For example:

Category a = 1,2,3

Category b = 3,1,2

etc...

Each value in the triplet is either 1, 2 or 3.

I need to be able to input 3 values (also 1,2 or 3) into 3 cells, and I need the corresponding category to be displayed next to them (based on the 8 hard coded variants).

For example: if I were to enter 3 1 2 into the three cells, "Category b" would show up in the 4th cell.

Here is a screenshot of what I need:

The yellow cells are hard coded.

I have a long list of green cells.

I need to calculate the category in the blue cells based on the green cells.

`Index/Match` with multiple criteria? Also, are the `1,2,3` in the category names in the same cell, or separate cells? — BruceWayne, Aug 25 '17 at 16:21
Yup need more; a table with cell references and what you have tried. — Scott Craner, Aug 25 '17 at 16:23
[`Index/Match` with multiple criteria](https://www.deskbright.com/excel/index-match-multiple-criteria/) is one way to do it. — BruceWayne, Aug 25 '17 at 16:32
https://stackoverflow.com/questions/42492758/vlookup-using-2-columns-to-reference-another — Scott Craner, Aug 25 '17 at 16:33

score 2 · Accepted Answer · answered Aug 25 '17 at 16:38

2

use this in E2:

 =INDEX(G:G,AGGREGATE(15,6,ROW($G$2:$G$9)/(($H$2:$H$9=B2)*($I$2:$I$9=C2)*($J$2:$J$9=D2)),1))

Then copy down

answered Aug 25 '17 at 16:38

Scott Craner

148,073
10
49
81

Output category based on multiple inputs

1 Answers1