View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Faraz A. Qureshi Faraz A. Qureshi is offline
external usenet poster
 
Posts: 211
Default LOOKUP on multiple conditions

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