FreeKB - 0 Understanding vlookup in Excel
Understanding vlookup in Excel

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 aa126 in the box below so that we can be sure you are a human.


Web design by yours truely - me, myself, and I   |   |