Microsoft Excel

Learn How to Get First Text Value in List in Microsoft Excel

Learn How to Get First Text Value in List in Microsoft Excel

The main purpose of this formula is to get the first text value in a list in a one-column range. Here we will learn how to get the first text value in the list in the given data range in the workbook in Microsoft Excel.

That implies, with the help of a formula based on the VLOOKUP function, you can able to get the first text value in a list in a one-column range.

So, with the help of this formula, you can able to get the first text value in the list in the given data range in the workbook in Microsoft Excel.

 

General Formula to Get First Text Value in List

=VLOOKUP(“*”,range,1,FALSE)

 

The Explanation to Get First Text Value in the List

Learn How to Get First Text Value in List in Microsoft Excel

 

So we know that with the help of the given formula above, you can able to get the first text value in a list in a one-column range. Here we will learn how to get the first text value in the list in the given data range in the workbook in Microsoft Excel.

As we know that the asterisk (*) wildcard character matches any text value. While using VLOOKUP in exact match mode, the asterisk will match the first cell that contains the text.

Since we are supplying the column as 1, we get the value from the same range we are using for the table. So now you have learned how to get the first text value in the list in the given data range in the workbook in Microsoft Excel.