If formula that will check certain conditons

Hi All,

i need all your expertise for this issue that i have...


I have here the list of customers provided from column A to D:

data 1.JPG

These customers are external customers and i have the extracted data from column F to K.

Capture.JPG

In column F, this is where the customers in from column A is linked.

Now, what i have to do is to to unlink the customers in column A to the customers in column F.
If the organization, distribution channel and divison of the customer in column F is = to the organization, distribution channel and divison of the customer in column A then the validation should be "UNLINK".

das.JPG


If the organization, distribution channel and division is not equal, the validation should be "No action".

last.JPG

Can someone help me regarding this matter?

Hi TMS, thanks alot for your immediate response. is it actually possible to add the the customer number in Column K - just to be sure that we are cehcking same customer as per column A?

Hi geliedee,

Try This

=IF(IFERROR(VLOOKUP($G3,$B$2:$B$1048576,1,0),"")=$G3,"Unlink","No Action")

thanks
Rohit

hI Rohit_Raj, I think i cant use vlookup in this case since there are multiple criteria - org. channel and division.

Thanks TMS! worked fine. And thanks again for the explanation