Hello! Right now in Google Sheets I have a code that looks at an imported feed that tells me if the value in column A is found in Import_Sheet (either 'Yes' or 'No').
What I would like for this to do, is if the cell in column A is empty it will also show 'No'. Right now it just shows a blank cell. I've been trying to inject this snippet, but wherever I put it, it completely breaks the code:
Any ideas how I could get this to work? Another way that doesn't use ISBLANK would be fine too, as long as it prints 'No' for empty cells.
Code:
=arrayformula(if(A2:A<>"",if(isna(vlookup(A2:A,Import_Sheet!A:A,1,false))=false,"Yes","No"),""))
What I would like for this to do, is if the cell in column A is empty it will also show 'No'. Right now it just shows a blank cell. I've been trying to inject this snippet, but wherever I put it, it completely breaks the code:
Code:
IF(ISBLANK(A2),"No",A2)
Any ideas how I could get this to work? Another way that doesn't use ISBLANK would be fine too, as long as it prints 'No' for empty cells.