SUMPRODUCT

Or if you gave a little example it would be easier to explain

"luckyie" wrote:

Hi everyone,

I am trying to creata a formula that will return a value depending on 3
criteria. With Vlookup I could only find the formula retrieving a value based
on one criteria. Any idea on how to return a value based on 3 criteria. tks
--
lucky