Index experts needed

[churmie]

Hi

I am trying to build a spreadsheet that will produce several results based on referencing one value in one particular cell.

How do I build a formula that will produce the results like in Match? Leaving blanks if the incorrect Animal I input in Lookup?

Any help will be HUGELY appreciated!

The example is below:

Lookup: Fox

Animal Name Colour Origin Owner
Match: Fox Dave Red US No
Fox Harry Red Italy No

	A	B	C	D	E
1	ANIMAL	NAME	COLOUR	ORIGIN	OWNER
2	Fox	Dave	Red	US	No
3	Rabbit	Steve	Grey	Italy	Yes
4	Rabbit	John	Black	Germany	Yes
5	Dog	Chris	White	UK	Yes
6	Cat	Brian	Ginger	UK	Yes
7	Fox	Harry	Red	Italy	No
8	Dog	Derek	Red	Denmark	Yes
9	Cat	Kane	Red	France	No

<tbody>
</tbody>

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1046822-index-experts-needed.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

I also do not understand why you re-posted it, when you already got a response to your original question which you have not responded to...