INDEX/MATCH Issues

[patrick_oneal]

Name	Type	Clean Data		DOGS	CATS
FRANK	-DOG	DOG		FRANK	JEFF
JEFF	-CAT	CAT		AMY	KELLY
KELLY	-CAT	CAT
AMY	-DOG	DOG

<tbody>
</tbody>

I'm trying to grasp index, match to work on a spread sheet. All of the other questions I find are not helping all that much.

Cells E/D (DOGS,CATS) is what I want the output to look like, I want to match all data in the C column to cell E1 (DOGS), and display the name.

{=INDEX($A$2:$C$5,MATCH($E$1,$C2:$C$5,0),1)}

 

[Special-K99]

1. Make your data consistent.
In the output change the column heading to DOG and CAT, not DOGS and CATS

2. in H2
=IFERROR(INDEX($A$2:$A$5,AGGREGATE(15,6,ROW($A$2:$A$5)/(($C$2:$C$5=E$1)),ROWS(A$2:A2))-(2-1),1),"")
copy across and down for as many rows as you have names in column A (in this case down to row 5)

 

[DanteAmor]

Check the following data

Excel Workbook
	A	B	C	D	E	F
1	Name	Type	Clean Data		DOG	CAT
2	FRANK	-DOG	DOG		FRANK	JEFF
3	JEFF	-CAT	CAT		AMY	KELLY
4	KELLY	-CAT	CAT
5	AMY	-DOG	DOG
6
7
8
9
10
Hoja4

 

[patrick_oneal]

I utilized this code and was successful, thank you. What is i wanted to add another column for color and look for items that matched say “DOG & Brown?”

 

[Special-K99]

"I utlilized this code"
To whom are you referring, you have two answers but used only one solution?

Wiht "Brown" in column D
=IFERROR(INDEX($A$2:$A$5,AGGREGATE(15,6,ROW($A$2:$A$5)/(($C$2:$C$5=E$1)*(D$2:D$5="Brown"),ROWS(A$2:A2))-(2-1),1),"")

 

[DanteAmor]

I utilized this code and was successful, thank you.

You're welcome.

If you present your idea of ​​how you have your data and how you want the results we could establish a formula.
Maybe, it would be better to use a pivot table.