match row range data

[rachelwahid]

Dear Expert,
In my worksheet A column name A1= "Print", B column name B1="Emb", C column C1="Wash" and D column D1="Result"
i need result as below:
if a2="yes", B2="No", C2="No" then d2 will "Print" (considering column heading), otherwise if "yes" not available A2,b2,c2 then d2= "No Embellishment".
If "yes" found multi column then d2 will both column name like A2="Yes" & C2=Yes" then d2="Print/Wash".

Attached file for your ref. (i need column D result automatic).

Please help me in this regard.

Regards
Wahid

[maclearyj]

Spreadsheet attached with code for you:

[rachelwahid]

Dear Expert,
its working properly.

Thanks a lot.

[maclearyj]

You're welcome and thanks for the feedback.

[rachelwahid]

Dear Expert,
On my post1, i want to get result based on "Yes" and that i already get.
But this time i need also this result based on "No".

In my worksheet A column name A1= "Print", B column name B1="Emb", C column C1="Wash" and D column D1="Result"
i need result as below:
if a2=Any character or word, B2="No", C2="No" then d2 will "Print" (considering column heading), otherwise if "No" not available A2,b2,c2 then d2= "Print/Emb/Wash".
If "No" found multi column then d2 will other both column name like A2=Any character or word & C2=Any character or word then d2="Print/Wash".

Attached file for your ref. (i need column D result automatic).

Please help me in this regard.

Regards
Wahid

[maclearyj]

Hello. I have changed it by reversing the formulas from before, so for example where it looked for A2="yes", it now looks for A2 not equal "No". I think this is what you are asking for.

[rachelwahid]

Dear Maclearyj,
Great thanks for your great support. its working.

[maclearyj]

You are welcome. Please click on the *Add Reputation under my last post to improve my standing in the community.