If you need to get the first text value in a list (a one-column range) you can use the VLOOKUP function set to exact match, with a wildcard character for the lookup value.
In the example the formula in D7 is:
=VLOOKUP("*",B5:B11,1,FALSE)
=VLOOKUP("*",range,1,FALSE)The asterisk (*) wildcard character matches any text value. When used with VLOOKUP in exact match mode (the 4th argument, range_lookup, set to FALSE), the asterisk will match the first cell that contains text. Since we are supplying the column as 1, we get the value from the same range we are using for the table.
Note: this only works for text values, not numbers.
Author
Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.
View Paid Training & Bundles
