The index and match work together to look at the prior row to see if is already listed to generate the unique list. I would like to wrap this formula around another index to get the result from another column. I think I need to convert this formula to a row number. Here is the spreadsheet.

Book1 | |||||||
---|---|---|---|---|---|---|---|

A | B | C | D | E | |||

1 | Type | Brand | Combo | Unique List | |||

2 | Computer | A | Computer-A | Computer-A | |||

3 | Phone | B | Phone-B | Phone-B | |||

4 | Computer | A | Computer-A | Car-C | |||

5 | Car | C | Car-C | Computer-B | |||

6 | Computer | B | Computer-B | ||||

7 | |||||||

8 | Result I want | ||||||

9 | Type | Brand | |||||

10 | Computer | A | |||||

11 | Phone | B | |||||

12 | Car | C | |||||

13 | Computer | B | |||||

Sheet2 |

Cell Formulas | ||
---|---|---|

Range | Formula | |

E2:E5 | E2 | =INDEX($C$2:$C$6,MATCH(0,COUNTIFS($E$1:$E1,$C$2:$C$6),0)) |

C2:C6 | C2 | =A2&"-"&B2 |

Press CTRL+SHIFT+ENTER to enter array formulas. |

I tried

=INDEX($A$2:$A$6,INDEX($C$2:$C$6,MATCH(0,COUNTIFS($E$1:$E1,$C$2:$C$6),0)))

Is this possible with this type of formula?