How INDEX/MATCH works: the essential guide with examples скачать в хорошем качестве

How INDEX/MATCH works: the essential guide with examples

Are you looking for a function to overcome VLOOKUP and HLOOKUP limitations? Well, you came to the right place! In this video, I’ll show you how to use the INDEX/MATCH function combination to merge databases in an extremely flexible way. We’ll first see what the INDEX and MATCH functions do independently, and then we’ll learn how to combine them together. The final formula is going to be a bit long, but the more you’ll use it, the easier it will be to remember it. Timestamps: 00:00 Introduction to INDEX/MATCH and why it is useful 01:44 How to use INDEX 02:50 How to use MATCH 04:10 How to combine INDEX and MATCH 10:15 Why INDEX/MATCH is better than VLOOKUP or HLOOKUP Download the workbook and practice at your own pace: https://bit.ly/3NQpxs7 The link opens a google docs page. Once there, click on File, then Download, and finally Microsoft Excel.