What is VLOOKUP

VLOOKUP is a powerful function in Excel."V" in VLOOKUP stands for "Vertical," indicating that it searches vertically (downward) in a table. www.safalta.com {"vars":{"account":"G-TSX1HMG1ZL"},"triggers":{"trackPageview":{"on":"visible","request":"pageview","vars":{"title":"How To Use VLOOKUP In Excel","ampdocUrl":"https://www.safalta.com/web-stories/online-digital-marketing/marketing-basics/importance-of-vlookup-in-excel"}}}} {"vars":{"account":"G-Q0NES8G294"},"triggers":{"trackPageview":{"on":"visible","request":"pageview","vars":{"title":"How To Use VLOOKUP In Excel","ampdocUrl":"https://www.safalta.com/web-stories/online-digital-marketing/marketing-basics/importance-of-vlookup-in-excel"}}}} {"vars":{"account":"UA-150254232-4"},"triggers":{"trackPageview":{"on":"visible","request":"pageview","vars":{"title":"How To Use VLOOKUP In Excel","ampdocUrl":"https://www.safalta.com/web-stories/online-digital-marketing/marketing-basics/importance-of-vlookup-in-excel"}}}} {"vars":{"c2":"21916725"},"extraUrlParams":{"comscorekw":"amp"}}

How to Use VLOOKUP in Excel

Prepare your data and Determine what you want to look up

Determine what you want to look up:

Identify the value you want to search for in the leftmost column of your table.

Select the cell where you want the result to appear

Click on the cell where you want the result of the VLOOKUP function to be displayed.

. Enter the VLOOKUP function

Type "=" (equals sign) in the selected cell to start a formula, then type "VLOOKUP(". This will prompt Excel to expect the arguments for the VLOOKUP function.

To Boost your career with Safalta and read educational stories

Browse More Stories www.safalta.com