You are very welcome, Sweepea, thank you for your feedback.

One additional consideration. As Dave notes, this currently assumes the
criteria are met. If the value in column C for a valid combination like Apple
and Fuji could be 0, there would be no distinction between not finding the
combination (e.g. through inaccurate search critera or data) and finding it,
both giving 0 in that particular case. The expression can be extended to
cover this by verifying the existence of the search criteria in the data.

Anthony

"Sweepea" wrote:

Thank you, Anthony. The formula is easy and it really helps.

But I will try Dave's method as well.

Thanks everyone for your help .... most sincerely appreciated.


"Anthony D" wrote:

Hi,

A possibility using sumproduct:

=SUMPRODUCT(--(A1:A1="Apple"),--(B1:B1="Fuji"),C1:C1)

The range can be extended e.g. A1:A100, B1:B100, C1:C100 etc.

Hth
Anthony

"Sweepea" wrote:

Example:

C1 C2 C3
R1 Apple Fuji 10

I want to create a lookup that will return the value 10 if C1=Apple AND
C2=Fuji.
Can someone help? Thank you.