If you dont have duplicates the below will return the entry in Col C greater
than 10,000. If there are more entries above 10,000 the below will return the
sum

=SUMPRODUCT(--(A1:A100="A"),--(B1:B100="X"),--(C1:C10010000),C1:C100)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Can one of you kindly devise me a formula/UDF for me so as to apply the
V/HLOOKUP on multiple conditions without creating a helper column?

For instance returning the column D's entry where Column A's entry has "A"
and Column B's entry is "X" and Value in Column C is greater than 10,000?

Thanx in advance.

--
Best Regards,

Faraz