Having trouble getting my head round how to solve the following. Have been trying various combinations of Match and Index, but am struggling to get my head around how the two formulas work together - each time I think i have it, it just returns N/A.

As a leading biological researcher I have the following headings in row A

Animal, Habitat, Noise, Food, Number of Legs

And appropriate values for many animals completed in the columns below -

Dog, Kennel, Woof, Bone,4.

Cat,House,Meow,Fish,4

If I had a value of Meow, could I use an Index, Match formula to return 'Noise'? Meow is a unique value, and won't appear in any other columns.

Any pointers much appreciated,