Search code examples
google-sheetsformulas

If cell is blank preform formula else use value

I'm trying to conditionally set the value of a cell if there isn't already a value in it. I want to use a separate column so as to not lose the formula if a value is put in. This is what I'm trying. It's just saying FALSE in the cell

=IF(ISBLANK(D2),D2=FILTER(Characters!G3:G9,Characters!B3:B9 = B2))
Solution

  • Remove D2=

    =IF(ISBLANK(D2),FILTER(Characters!G3:G9,Characters!B3:B9 = B2))