XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP) скачать в хорошем качестве

XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP)

Want to learn XLOOKUP? You have come to the right place. "XLOOKUP is probably the most powerful XL function" - my grandma How to use XLOOKUP? =XLOOKUP( value you want to find, in the column where your data is, specify the column you want as a result) XLOOKUP Example 1: =XLOOKUP( "Richard", B8:B42, H8:H42) XLOOKUP Example 2: =XLOOKUP( "EMP1012", C8:C42, B8:B42, "Person not found") Why use XLOOKUP? XLOOKUP is an easy, versatile and powerful XL function that let's you search what you want in your data and get matching results. It is better version of VLOOKUP and INDEX+MATCH functions. In this 6 minute video, learn how to use XLOOKUP in Microsoft Excel. The video explains: ✅ How to use XLOOKUP? ✅What happens when XLOOKUP can't find the value? ✅XLOOKUP and returning the entire row ✅XLOOKUP with two sheets More Excel XLOOKUP examples and explanation: Read my detailed XLOOKUP article for full information - https://chandoo.org/wp/xlookup-examples/ XLOOKUP Sample file - https://chandoo.org/wp/wp-content/upl... XLOOKUP Advanced Techniques (10 powerful examples) -    • 10 Advanced XLOOKUP Tips & Tricks   I stopped using VLOOKUP, here is why -    • I don't use VLOOKUP anymore. I use this in...   ~ =XLOOKUP("best day ever", days, you) #xlookup #excel