![]() Let's look at the Starbucks menu as an example. Once it finds a match, the vlookup will return a value from any cell in the same row as the match. The job of the vlookup is to look for a value (either numbers or text) in a column. And even if you're already a vlookup expert, this might help you explain the function to your co-workers. So I thought this might be a good way to explain the vlookup because everyone can relate to ordering from a food menu. I was standing in line at Starbucks the other day, studying the prices on the menu, and I realized I was doing a bunch of vlookups in my head.Īs I scanned down the items on the menu and then looked across to the price columns, I was doing the same thing a vlookup function does. Plus, you will never look at a restaurant menu the same way again… □ Vlookups at Starbucks? I provide a step-by-step guide on how to write a vlookup formula and you can download an Excel file to follow along. In this article you will learn the basic concepts of the VLOOKUP function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |