## How to vlookup in Excel 2007/2010

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