Using IF with vlookup and Multiple AND & OR Logics

[IkramRaja]

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

[kersplash]

Attach a sample workbook showing what you are trying to achieve. Also any attempt you've tried may actually help.

Go Advanced -> Manage Attachments -> Upload

[AliGW]

Welcome to the forum!

What you have tried should work:

=IF(AND(VLOOKUP(vlookup_1)="A",VLOOKUP(vlookup_2)="B",VLOOKUP(vlookup_3)="C"),"Deal Cancelled","Deal Active")

I have used AND (not OR) as you state that all criteria must be met. OR would require just one (or more) of them to be met.