Help Please

[D. D. Scopes]

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

 

[Peo Sjoblom]

=IF(A1=B1,C1,"")

--
Regards,

Peo Sjoblom

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

 

[Dave R.]

Try

=INDEX(C1:C100,MATCH(1,(A1:A100="Lookup1")*(B1:B100="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]

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

 

[Peo Sjoblom]

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)