How to Edit VLookup

By Tara Kimball

When you need to sift through large amounts of data to identify specific values in an Excel spreadsheet, the VLOOKUP command can save you hours of manually searching for information. Once you set the VLOOKUP command, you can edit it as necessary to modify the final results.

Locate the cell with the VLOOKUP command and click it with your mouse to place the Excel cursor on it.

Click the formula bar where the VLOOKUP function appears at the top of your Excel window.

Edit the first value to change what the function is looking for. Edit the second value, separated with a comma, to clarify which columns and cells are part of the function.

Edit the third value to change which column the result comes from and change the final section to specify an exact match or the next lowest value if a match is not available.

×