How to delete contents of another cell if current cell has a specific value

[blank___space]

Hi, I made this sample file. I would like to do the following under Nov Sales Sheet.

https://docs.google.com/spreadsheets/d/1OawXSruy50khcw_zQDQtd7vhPlslpmsQUR-gUoCgrU4/edit?usp=sharing

If SALE(C5) = "Y"(a drop down Y and N list), I would like to delete the contents of "SELLING FOR.(E5)"
and same thing if SALE = "N" I would like to delete the contents of "SALE PRICE"(F5).

I don't think it's do-able with Conditional Formatting.

Note: both SELLING FOR(E5) and SALE PRICE (F5) column pulls up report from another worksheet and has this formula:

=IFERROR(VLOOKUP(B5,INVENTORY!<wbr>$A$8:$P$88,10,FALSE),0)

and =IFERROR(VLOOKUP(B5,INVENTORY!<wbr>$A$8:$P$88,11,FALSE),0) respectively.

 

[Dim Me as xlNoob]

You can just include an IF function like this:

E5 = IF(C5 = "N", IFERROR(VLOOKUP(B5,INVENTORY!<wbr style="color: rgb(51, 51, 51); font-family: Roboto; background-color: rgb(250, 250, 250);">$A$8:$P$88,10,FALSE),0), "")

F5 = IF(C5 = "Y", IFERROR(VLOOKUP(B5,INVENTORY!<wbr style="color: rgb(51, 51, 51); font-family: Roboto; background-color: rgb(250, 250, 250);">$A$8:$P$88,11,FALSE),0), "")

Or if you just want the cell to go to a 0 value instead of completely empty:

E5 = IF(C5 = "N", IFERROR(VLOOKUP(B5,INVENTORY!<wbr style="color: rgb(51, 51, 51); font-family: Roboto; background-color: rgb(250, 250, 250);">$A$8:$P$88,10,FALSE),0), 0)

F5 = IF(C5 = "Y", IFERROR(VLOOKUP(B5,INVENTORY!<wbr style="color: rgb(51, 51, 51); font-family: Roboto; background-color: rgb(250, 250, 250);">$A$8:$P$88,11,FALSE),0), 0)

 

[blank___space]

awesome! That worked perfectly thanks!

 

[Dim Me as xlNoob]

Glad to help