Actually i want a formula that can enable my get the result as follows:

if

using AND meeting multiple criteria and using Vlookup i.e.

vlookup result 1 = A, vlookup result 2 = B, vlookup result 3 = C

with this using OR function with vlookup i.e

vlookup result 4 = D

and if all the above conditions meet the result should be "Deal Cancelled"

if not then "Deal Active"

I have tried to use this formula but unable to get a result.


need help and suggestions. :-)

Thanks