Tip Printed from ExcelTip.com

---

Retrieving the Value of the First Nonblank Cell in a List


Problem:

Retrieving the value of the first non-blank cell in Range1(A2:A7).

Solution:
Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX(A2:A7,MATCH(TRUE,A2:A7<>"""",0))}


Example:
Range1


X

Y
Z

Result X