Author: Analyst

How to vlookup in Excel 2007/2010

Posted by | Sep 12, 2013 | |

Do you want to use Excel more efficiently? Do you want to be able to go home earlier? If you answered yes to either of these questions, then read on. The vlookup is the most useful, yet most mis-understood function in Excel.And vlookup in Excel 2007/2010 is very powerful This is a step by step vlookup tutorial (only 7 steps) suitable for beginners and made more interesting by including Usain Bolt, as it’s the quickest (and simplest) way to do a vlookup!! This method works in Excel 2003, Excel 2007, and Excel 2010 (you just need to find the fx button above column B demonstrated in the example below). LEARN HOW TO USE THE VLOOKUP FUNCTION IN EXCEL AND SAVE YOURSELF HOURS WITH ANALYSIS!! vlookups are usually done between different spreadsheets, but to make it easier to show how they work, I’ve put the data on to one spreadsheet in the table in the first image below. The table has some of the most famous 100m runners in the world. They are numbered from 1 to 10 in column B (the numbers are for illustrative purposes only). I’ve put the names of the athletes in column C. IMPORTANT: You should note that the table on the LEFT HAND SIDE is set in ASCENDING NUMERCIAL order ie numbers 1 to 10. However, the table on the RIGHT HAND SIDE is...

Read More

Vlookup Between Two Workbooks

Posted by | Sep 2, 2013 | |

Vlookup between two workbooks / Vlookup between multiple worksheets  Below is an example of a vlookup between two different workbooks, which a lot of you have been asking about. To make it as easy as possible for you to understand the steps, we’ve included the two files we use for the tutorial here: Workbook without prices and Workbook with prices. You can’t learn how to drive a car by just reading a book, and for that reason, we’ve given you access to the files that we use – after all, the best way to learn is by doing! Other sites do not offer you the files, but we do. We recommend that you have both files open before you begin the tutorial. The workbooks contain a list of products which the majority of people would buy in a supermarket – Milk, Bread, Jam, etc. We have intentionally kept the files simple. We’re going to use the vlookup function to get the prices of the food data from the “workbook with prices” into the “workbook without prices”. Step 1 When you open the “workbook without prices” file you will see the screen below. Column C in the “sheet without prices” in this workbook is where we will pull in the “Price of the Goods” from the other workbook. Cell C2 will already be selected – if it isn’t, click in cell...

Read More

How to do a vlookup in Excel 2003

Posted by | Oct 16, 2012 | |

Do you want to become a vlookup expert? Do you want to save time looking up data at work? If you answered yes to either of these questions, then read on. The vlookup is the most useful, yet most mis-understood function in Excel! And yet vlookup in Excel 2003 can be so handy! This is a step by step vlookup tutorial (only 7 steps) made more interesting by including Usain Bolt, as it’s the quickest (and simplest) way to do a vlookup!! This method works in Excel 2003, Excel 2007, and Excel 2010 (you just need to find the fx button above column B demonstrated in the example below).   LEARN HOW TO USE THE VLOOKUP FUNCTION IN EXCEL AND SAVE YOURSELF HOURS WITH ANALYSIS!! vlookups are usually done between different spreadsheets, but to make it easier to show how they work, I’ve put the sets of data on to one spreadsheet in the table in the first image below. The table has some of the most famous 100m runners in the world. They are numbered from 1 to 10 in column B (the numbers are for illustrative purposes only). I’ve put the names of the athletes in column C. IMPORTANT: You should note that the table on the LEFT HAND SIDE is set in ASCENDING NUMERCIAL order ie numbers 1 to 10. However, the table on the RIGHT...

Read More

"It's here! A step by step Pivot Table Tutorial