If cell in Col A = x and adjoining cell in col B = y then return cell in Col C

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

Amazingly lightning fast response! I thank you so much for your time. As you've probably guessed I'm not managing a DB of deformed cats, so I will try this with my live-fire data and report back on how it goes.

Thanks again.

So I had to work out how you aliased the cell ranges (only worked it out after spotting your deliberate spelling mistake) but now I've cracked it.

The Name Manager will make my life even easier as I can define named ranges for external sheets before they even exist.

This is awesome. You've just upped my Excel game 100%. Cheers man.