- #How to use vlookup in excel 2013 for dummies how to#
- #How to use vlookup in excel 2013 for dummies free#
If you want to actually test out the instructions below with exactly the same data in Excel, then we have included a link to the file with the data here –įirst, click into cell D2 – as this is where we want the first vlookup result to appear.Ĭlick on the ‘fx’ button above column B – many people start by typing “=vlookup…” but you don’t have to! Clicking the “fx” button is much quicker! We’ll use the vlookup function to get the ‘Prize Money’ each athlete has won in column J in the second table into column D in the first table. So the numbers in that table DO NOT go from 1 to 10 in ascending order. However, the table on the RIGHT HAND SIDE is arranged in ALPHABETICAL order of the names of the athletes. IMPORTANT: You should note that the table on the LEFT HAND SIDE is set in ASCENDING NUMERCIAL order ie numbers 1 to 10.
I’ve put the names of the runners / athletes in column C. The runners are numbered from 1 to 10 in column B (the numbers are for illustrative purposes only). The tables in the spreadsheet have some of the most famous 100m runners in the world – including Usain Bolt (the World Champion!). 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 (see image below).
#How to use vlookup in excel 2013 for dummies how to#
LEARN HOW TO USE THE VLOOKUP FUNCTION IN EXCEL AND SAVE YOURSELF HOURS WITH ANALYSIS!! It’s the quickest and simplest way to do a vlookup! It works in all versions of Excel – Excel 2007, Excel 2010, Excel 2013, Excel 2016, Office 365, etc (you just need to find the fx button above column B as shown in the example below). This is a step by step vlookup tutorial (only 7 steps) suitable for beginners. Learning how to vlookup in Excel 2007/2010/2013/2016 and the Excel version in Office 365 can be very useful. The vlookup is the most useful, yet most mis-understood function in Excel.
#How to use vlookup in excel 2013 for dummies free#
Use this file to go try out what is shown in this free excel video tutorial. We’ve also created a video version of the tutorial which you can watch here.
If you answered yes to either of these questions, then read on.īut before we proceed, many of you have been asking for a step by step tutorial on Pivot Tables, which is now here: Pivot Tables in Excel.We’ve also launched Working with Numbers. “This is the quickest I have come across!!!! You are a big help.” Ron