| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieving first non-blank cell during a V-LOOKUP
Hi all,
I am looking to use the VLOOKUP function to caputure the contents of the first nonblank cell. At the moment, I am capturing the first match - which may be blank or non blank. How do I capture non-blank cells only? Thank you. Clarissa. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup based on 1st non-blank cell | Excel Worksheet Functions | |||
| Show a blank result in a cell when there is no value in the "Lookup" cell | New Users to Excel | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
| Returning a blank cell rather then #N/A (Lookup) | Excel Discussion (Misc queries) | |||
| Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Threaded Mode
