How to do a 2 way Lookup in Excel Advanced MATCH and VLOOKUP Tutorial - NO MUSIC Version

A quick and easy tutorial on how to perform a 2-way lookup in Excel. Download the file used in this video and see more tips at http://software-matters.co.uk/microsoft-excel-help-and-tips.html#download. A 2-way lookup uses 2 pieces of lookup information to identify a piece of data, and can be done in Excel using the MATCH and VLOOKUP functions.

This is an amended no music version of our 2-way Lookups video. For the original version: https://www.youtube.com/watch?v=4jCCaWR-8-M

See more tips:
http://www.software-matters.co.uk/youtube_links.html

----------
Visit the Software-Matters website:
http://www.software-matters.co.uk/

Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.
----------

Chapters

0:00 Introduction
0:20 What is a 2-way Lookup?
1:10 The MATCH Function
1:47 Naming the Ranges
2:38 Writing the MATCH and VLOOKUP Formula
3:44 2-way Lookup Example
5:00 2-way Lookup Formula
6:12 IFERROR Functions
6:30 Finishing the Lookup
7:09 Conclusion

Видео How to do a 2 way Lookup in Excel Advanced MATCH and VLOOKUP Tutorial - NO MUSIC Version канала Software-Matters