I have this formula `=IF(Sheet1!C2="x", Sheet1!B2,"")`

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

in column `C`

is same as the character of `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`

enter image description here

and here's the result using the formula enter image description here

but what I wanted is enter image description here

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

.