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

preview_player
Показать описание

See more tips:

Music:
George Street Shuffle - Kevin MacLeod
----------
Visit the Software-Matters website:

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:19 What is a 2-way Lookup?
1:03 The MATCH Function
1:34 Naming the Ranges
2:15 Writing the MATCH and VLOOKUP Formula
3:11 2-way Lookup Example
4:06 2-way Lookup Formula
5:01 IFERROR Functions
5:13 Finishing the Lookup
5:52 Conclusion
Рекомендации по теме
Комментарии
Автор

You are Godsend, Thank you. Trying to write a Beam Analysis Sheet which uses two way matrix math.

miketu