Try this and copy down

=IF(COUNTIF(A:A,B1)0,C1,"")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"D. D. Scopes" wrote in message
...
Dave tried it and i gives an #N/A error.

Say the formula is in column D.

I am looking for it to return the value in C3 if there is a match for B3
anywhere in column A.

Thanks.

DD


"Dave R." wrote in message
...
Try

=INDEX(C1:C100,MATCH(1,(A1:A100="Lookup1")*(B1:B10 0="Lookup2"),0))

where C1:C100 contains the values (3rd column)

You must enter this with CTRL SHIFT ENTER.

It works by finding a 1 in the array of numbers returned by the
A1:A100="Lookup1"*B1:B100="Lookup2". When there is not lookup1 and
lookup2
in the same row, a 0 will be returned. When they are in the same row, a 1
will be returned, which will be matched by the 1 you're looking for, and
the
position will be used by the INDEX part to give you the number.



"D. D. Scopes" wrote in message
...
I am looking for a formula that will search 2 columns for identical
matches
and when found return a value from a third colum.

Thank you.

DD