» Retrieving the Value of the First Non-Blank Cell in a List
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem: Retrieving the value of the first non-blank cell in Range1 (cells A2:A7).
Solution:
Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX(A2:A7,MATCH(TRUE,A2:A7<>"",0))}
To apply Array formula:
Select the cell, press
Book Store:
No comments have been submitted.

