Get the first non-empty cell in a column in Excel and Google Sheets

  1. =INDEX(A:A, MATCH(FALSE, ISBLANK(A:A), 0)) // doesn't ignore errors

  2. =INDEX(A:A,MATCH(TRUE,INDEX((A:A<>0),0),0)) // ignore errors

  3. =INDEX(A:A,MATCH(TRUE,A:A<>"",0)) // ignore errors

  4. =VLOOKUP("*", A:A, 1,FALSE) // ignore errors

  5. =INDEX(A:A,MATCH(TRUE,INDEX(ISNUMBER(A:A),0),0)) // to get the first numeric value in Excel and ignore errors

  6. =INDEX(A:A,MATCH(TRUE,INDEX(ISTEXT(A:A),0),0)) // to get the first text value in Excel and ignore errors

  7. =MATCH(TRUE,ISERROR(A:A),0) // to get the first error position in Excel

  8. =MATCH(FALSE,ISBLANK(A:A),0) // to get the first non-blank cell position in Excel

    • A:A = Ranges

Scroll below for Google Sheets

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.