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


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ANIMAL[/TD]
[TD]NAME[/TD]
[TD]COLOUR[/TD]
[TD]ORIGIN[/TD]
[TD]OWNER[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Fox[/TD]
[TD]Dave[/TD]
[TD]Red[/TD]
[TD]US[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Rabbit[/TD]
[TD]Steve[/TD]
[TD]Grey[/TD]
[TD]Italy[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Rabbit[/TD]
[TD]John[/TD]
[TD]Black[/TD]
[TD]Germany[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Dog[/TD]
[TD]Chris[/TD]
[TD]White[/TD]
[TD]UK[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Cat[/TD]
[TD]Brian[/TD]
[TD]Ginger[/TD]
[TD]UK[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Fox[/TD]
[TD]Harry[/TD]
[TD]Red[/TD]
[TD]Italy[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Dog[/TD]
[TD]Derek[/TD]
[TD]Red[/TD]
[TD]Denmark[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Cat[/TD]
[TD]Kane[/TD]
[TD]Red[/TD]
[TD]France[/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]

 

[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...