Understanding vlookup in Excel

Home > Search
  by

The vlookup command can be used to search for a certain string of data in Excel, and then return a related string of data. Let's take an example of a breakfast menu. Vlookup can be used to find the price of a certain item.

In this example, vlookup is used to search with the string of data in cell B8, which is pancakes in this example. Vlookup will search cells A1 through B6 for the work pancakes. If a result is found, the second column that contains the word pancakes will be displayed in the search results.



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter in the box below so that we can be sure you are a human.




Comments