Click the cell where you want the VLOOKUP formula to be calculated.
Go to the top of the screen and click “Formulas.”
Click on “Lookup and Reference” on the ribbon.
At the bottom of the drop-down menu, look for VLOOKUP.
Select the cell in which you want to apply the formula.
A VLOOKUP dialog box will open; specify the data you want to use for search in the “Table_array” box.
Specify the column number.
Specify “Range_Lookup” by entering either True or False. If you want an exact match, enter FALSE.
Click OK to continue.
Now enter the value for the data you are searching for.
VLOOKUP will automatically produce the desired result.
Viewing 1 post (of 1 total)
You must be logged in to reply to this topic. Login here