![]() Excel creates a nicely formatted table for you. Check 'My table has headers' and click on OK. ![]() Excel automatically selects the data for you. On the Insert tab, in the Tables group, click Table. Click any single cell inside the data set. In the popping Formula Helper dialog, click to select all the data range into Table_array, select the look up value into Look_ value, and then select the column range you want to return to Column. Select a cell to put the result, and click Kutools > Formulas > Look for a value in list. Specify the cell in which you will enter the value whose data you're looking for. Click "VLOOKUP" at the bottom of the drop-down menu. ![]() Click " Lookup & Reference" on the Ribbon. Click "Formula" at the top of the screen. FAQ about Kutools For Excel Review How do you do a LOOKUP function on Excel? Click the cell where you want the VLOOKUP formula to be calculated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |