| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving first non-blank cell during a V-LOOKUP
Hi Clarissa,
With these conditions, you will need array formulas ... Are you looking for the first non-blank value in a column or in a row ...? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving first non-blank cell during a V-LOOKUP
Hi Carim - in a Column.
"Carim" wrote: Hi Clarissa, With these conditions, you will need array formulas ... Are you looking for the first non-blank value in a column or in a row ...? |
|
#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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving first non-blank cell during a V-LOOKUP
Hi,
I was looking to use VLOOkUP to match the first non-blank cell, the formula you've kindly provided doesn't do that. Thank you for trying anyway. Clarissa "Carim" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving first non-blank cell during a V-LOOKUP
What does it do instead?
Clarissa wrote: Hi, I was looking to use VLOOkUP to match the first non-blank cell, the formula you've kindly provided doesn't do that. Thank you for trying anyway. Clarissa "Carim" wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Hybrid Mode
