In this article, I will tell you how to use the excel INDEX & MATCH function to find the first non-empty cell in a row or column, it will also tell you how to use the excel LOOKUPÂ function to find the last non-empty cell in a row or column with examples.