#1
|
|||
|
|||
Formula for blank cells
I am trying to write a formula that references a separate tab and takes the data that's currently in there and places it in the destination cell, but if the reference cell is blank leave the destination cell blank as well.
|
#2
|
|||
|
|||
There are multiple ways to do what you ask and here's just one...
=IF(Sheet2!A1<>"",Sheet2!A1,"") |
#3
|
|||
|
|||
When you are using some formulas that return error when the searced value doesn't exist, use ISERROR - like:
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP()) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting with blank cells | mummy | Excel | 1 | 09-02-2017 06:04 AM |
have a formula that combines two cells return a zero instead of a blank cell | Kubi | Excel | 3 | 08-07-2017 11:52 PM |
Help with Subtotal(103, ) formula and blank cells | zhl203 | Excel | 1 | 07-30-2014 03:40 PM |
Formula to hide '0' from blank referenced cells | formuladummy | Excel | 3 | 05-08-2014 02:33 AM |
Selecting blank cells in criteria | apolloman | Excel | 6 | 08-24-2011 05:38 AM |