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
<tbody>
</tbody>
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>