| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieving first non-blank cell during a V-LOOKUP
Ok then ...
Have a go with : =INDEX(A1:A100,MATCH(TRUE,A1:A100<"",0)) Instead of Enter, use Shift Control Enter keys simultaneously to input formula HTH |
| 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
