|
|
#3
09-11-2017, 10:19 PM
|
|||
|
|||
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 |
Windows 8 
Office 2016
Threaded Mode