Hello Excel gurus
My googling is not up to scratch enough today to help me get a grip of what I'm after.
I have a sheet that has several columns of data.
I need to find the values in cells in Col C.
I want to specify a set of searches that return values based on adjoining cells.
Here's a similar example to what I'm after
A B C 1 Cat Breed Cat Height Number of cats 2 Persian 10cm 72 3 Persian 15cm 12 4 Ginger 20cm 10 5 Ginger 25cm 5
So I want to say
Where Breed = Ginger AND Height = 25cm return number of cats
So it will send me C5 - 5
I'm guessing it's a VLOOKUP / MATCH combo query of some kind, but I have no idea of the syntax or semantics.
Can someone help me?
Thanks in advance,
Greg
Bookmarks