| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Empty Cells
When I do a lookup for a specific content of an array of cells that includes
blank cells I get different results if the blank cells have been cleared by setting them to "" vs cells that I have manually done a "Clear All" command. These cells are somehow different to the formula VLOOKUP($C37,Data!$A$5002:$N$9999,$GE37,FALSE), when $C37 is the blank cell and $GE37 is any number. In the case of the $C37 being cleared with "", I get a #Value result. In the case where $C37 has been manually cleared with a "Clear All" command I get an "ISNA" result. Is there a way with a Macro to clear all blank cells so they give the save results from the lookup equation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I shift the contents of the cells up to remove empty cells. | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Threaded Mode
