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]
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]