Get first text value with HLOOKUP in Excel
This tutorial shows how to Get first text value with HLOOKUP in Excel using the example below; Formula =HLOOKUP(“*”,range,1,FALSE) Explanation To lookup and retrieve the first text value across a range of columns, you can use the HLOOKUP function with a wildcard. In the example shown, the formula in F5 is: =HLOOKUP(“*”,C5:E5,1,0) How this formula works …