This book does a great job of explaining the Vlookup with multiple examples.Check it out here.I recently purchased a copy of Chandoos The VLOOKUP Book and realized that it was the first piece of material that I had read that covered pretty much all of the bases when it came to the Vlookup formula and other lookup.
Chandoo, I got my VLOOKUP book from Amazon yesterday and it looks like a great. The Vlookup, or vertical lookup is an Excel function that will search a table for a piece of data and then return a corresponding cell based on your input. It can be very powerful but there are a few things to know in order for it to work to its potential. As always, the best way to learn is through examples, so I am going to give 2 examples to explain the Vlookup. The Vlookup Book Chandoo Org Download The SampleTo download the sample Spreadsheet to follow along, For this example, we have the following spreadsheet. It is a few students and we want to find their grade in the larger table on right. So go to cell B2 and insert a function and insert the Vlookup function. We will need to fill it out as below: Lookup Value This is the cell we want to look for in the larger table. The left most column MUST contain the value we are looking for. If I used E1:G14, then when I would copy the formula down, in cell B2, the formula would become E2:G15 and keep increasing as you copy it down. Anleitung victoria 7910 pdfDollar signs () are anchors and that means the numbers wont change when you copy it down. ![]() Range Lookup This tells Excel if we are looking for an exact match or not. If we copy it down to C2 and D2, you will see the following results: I color coded it so you can see exactly where the matches are located. It starts at the top and works its way down until it finds the exact match. We put a 3 in the so it goes to the 3rd column and pulls in that field. If you look at the above for the name Joe, there are 2 instances of it. Excel just finds the first instance and pulls in the data from the 3rd column. Since we wont find an exact match most instances, we use TRUE. What Excel will do is look through the whole leftmost column of the table for an exact match.
0 Comments
Leave a Reply. |
AuthorChris ArchivesCategories |