I have this formula:

```
=IF(Sheet1!C2="x", Sheet1!B2,"")
```

Its function is to match if the cell from `Sheet1`

in column `C`

is the same as the character `x`

; if true then get the value of `Sheet1`

in column `B`

and if false leave it blank.

Here's the sample data of `Sheet1`

:

And here's the result using the formula:

But what I wanted is:

The blank cell happens because

```
=IF(Sheet1!C2="x", Sheet1!B2,"what to replace here to not to add a blank cell")
```