Create a helper column with Apple and fuji concatenated together. Then do
the lookup (or index) based upon that.

"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.