=INDEX(C1:C10,MATCH(1,(A1:A10="Tony")*(B1:B10="Phi l")*ISNUMBER(C1:C10),0))
array entered (ctrl+shift+enter)

will give you the first number where col A and Col B are tony and phil and
col C is a number.

"Phil" wrote in message
. uk...
Hi,
I am trying to find a formula that will look up a text value in Column A
then compare it to the corresponding cell in columnB and copy the numbers
in column c.
For instance...
Look down Column A for "Tony". If Tony is in ,say, A5 then look at B5 for
"Phil" and if B5 = Phil then copy number in C5. If B5 not equal to Phil
then do nothing.

Hope i explained it ok.
Thanks.