Thanx Kassie,
But It is not a single cell that I require. How to apply the same on columns
in complete?
--
Do check "Yes" if this post is helpful,
Best Regards,

Faraz


"Kassie" wrote:

=IF(AND(A1="A",B1="X"C110000),D1,"")
--
HTH

Kassie

Replace xxx with hotmail


"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