$a4

  1. C

    If X exists in $A3 and Y does not exist in $A3 then display Y

    I'm trying to compose a formula for if X exists in $A4 and Y does not exist in $A4 then insert Y Please see sample spreadsheet snippet below. The closest I've come is =IF(ISNUMBER(SEARCH(B$2,$A4)),B$3,"") which only checks if X exists then inserts Y. Having trouble with the "does not exist"...

Some videos you may like

This Week's Hot Topics

Top