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.
- The columns in your VLOOKUP should be sorted in ascending order for the command to function properly.
Tara Kimball is a former accounting professional with more than 10 years of experience in corporate finance and small business accounting. She has also worked in desktop support and network management. Her articles have appeared in various online publications.