Match all three to equal name

[pAPERCLIP20]

Excel Wizards,

I am looking for some sort of formula that gives an output if met under three conditions.

I have attached an example. I would like to show the name of the animal if the type, age, and legs match. Your help will be greatly appreciated. Thank you.EXCELHELP.xlsx

-Rachel

[FDibbins]

Hi and welcome to the forum

You didnt say where you will be putting the search criteria, so I used F1:H1.

There are (at least) 2 ways of doing this.

1. If you have lots of data, use this method. Add a helper column (I used E, use whatever you want, and you can hide it if you want), and copy this down...
=A2&B2&C2
Then, whereever you want the answer to be, use this...
=INDEX(D2:D5,MATCH(F1&G1&H1,E2:E5,0))

2. If you dont have a lot of data, you can se this ARRAY formula, which does away with the helper column, but could slow things down if you have lots of data...
=INDEX(D2:D5,MATCH(F1&G1&H1,A2:A5&B2:B5&C2:C5,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[martindwilson]

and another normally entered
=INDEX(D2:D100,MATCH(F1&G1&H1,INDEX(A2:A100&B2:B100&C2:C100,0),0))

[pAPERCLIP20]

Wow, thank you so much!