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