Hi,

Not clear; are you looking up the value in column C based on columns A and
B? You appear to be saying look up an item in column C based on items in
column C and in B and A - your ranges overlap and will return a circular
reference? Will the result be unique, is there only one item that will have
conditions x and y? If not what do you want to do?

Suppose the items are unique and the the entry you want to find is in column
D and its is a value, not text:

=SUMPRODUCT(--(A1:A10="x"),--(B1:B10="y"),--(C1:C10="z"),D1:D10)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ivan" wrote:

I need to look Up one value, but Using multiple variables, so for example
if(a=x and b=y and c=z, use value from C1, I tried doing a nested loop but
there are too many combinations and Excel says there are too many loops, does
someone know an easier way to do this?

Thanks