IF CELL IS ONE FROM A LIST, CLEAR ADJACENT CELL

[turkanet]

Dear friends,
I have a list in N2:N. I need to clear cell contents in rows of B2:B if row in C2:C is in N2:N
e.g.: if C4 exist in N2:N (matching completely, not partly), then B4 cell content must be cleared.

thank you in advance

 

[dreid1011]

What is entered in col B? Is it a formula or user entered data?
And when should col B be cleared? ie: when a change is made to the sheet, when the user decides, or some other event?

 

[turkanet]

dear dreid1011,
=IF(C2="",,"X") is in B2. i need to clear it like typing delete button from keyboard.

 

[dreid1011]

dear dreid1011,
=IF(C2="",,"X") is in B2. i need to clear it like typing delete button from keyboard.

You want to remove the formula then? Or still have the formula return "" if col C matches any value in col N?

 

[dreid1011]

Is this what you're after?

Book1
	A	B	C											N
1
2			Green											Red
3		X	Yello											Orange
4														Yellow
5														Green
6														Blue
7														Purple
Sheet2

Cell Formulas
Range	Formula
B2:B4	B2	=IF(C2="","",IF(ISNUMBER(MATCH(C2,$N$2:$N$7,0)),"","X"))

 

[turkanet]

i need b2 to be empty, witout any formula or something

 

[dreid1011]

i need b2 to be empty, witout any formula or something

Then you're going to need VBA. If you could answer the following questions from my post#2, it will help us on our way:

And when should col B be cleared? ie: when a change is made to the sheet, when the user decides, or some other event?

 

[turkanet]

Dreid, sorry. yes, i need vba. thank you

 

[dreid1011]

Dreid, sorry. yes, i need vba. thank you

You still have not answered the question... I cannot provide any solution without the answer.

Please tell me...

When should col B be cleared: Should it happen when any change is made to the worksheet, or a specific range? Does it happen when the user presses a button or runs the code? Or is there some other event to trigger the code?

 

[turkanet]

Dreid,
it happens when the user presses a button or runs the code