Choose HLOOKUP, and a Function Arguments dialog box will appear. In the Function Arguments dialog box, type the cell you want to change in the Lookup_ Value text box. In the Table_ Array text box ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

How to Identify One Word in a Cell in Excel. Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells.