LOOKUP on multiple conditions

[Faraz A. Qureshi]

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.

 

[Faraz A. Qureshi]

Thanx Jacob,

But sum is not required. It Column D may have numerical ast well as text
entries.

 

[Faraz A. Qureshi]

Thanx Kassie,
But It is not a single cell that I require. How to apply the same on columns
in complete?

 

[Jacob Skaria]

If you have text entries modify that to...

=INDEX($C$2:$C$100,MATCH(1,INDEX(($A$2:$A$100="A")*($B$2:$B$100="X")*(INT($C$2:$C$100)>10000),),),)

If this post helps click Yes