Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial. That video is uploaded by Chris Menard at 2021-05-13T08:30:15-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [poAdZpw7oL8]
| Name | Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial |
| Video Uploader | Video From Chris Menard |
| Upload Date | This Video Uploaded At 13-05-2021 15:30:15 |
| Video Discription | The XLOOKUP function in Excel allows you to perform a two-way lookup. The XLOOKUP function came out in 2019 and provides much more versatility than VLOOKUP and HLOOKUP. The XLOOKUP function will look up values LEFT, RIGHT, VERTICALLY, and HORIZONTALLY, it returns results based on multiple criteria, it performs an exact match by default, and finally, XLOOKUP will look from last to first. The key to creating a two-way lookup is to use nested XLOOKUP functions in a single statement or formula. In this video, I demonstrate how to do that by creating a two-way lookup across Q1, Q2, Q3, Q4, and also a number of employees to retrieve values in a bi-dimensional table... effectively creating a double XLOOKUP. XLOOKUP is much easier to explain, as a trainer, than VLOOKUP, and it's straightforward to demonstrate what it does and to verify if the values you're obtaining are correct. More relevant XLOOKUP videos: XLOOKUP presentation: https://www.youtube.com/watch?v=1sSje27jnTA XLOOKUP vs VLOOKUP: https://www.youtube.com/watch?v=w1uglE7AhPw Index & Match vs XLOOKUP: https://www.youtube.com/watch?v=fqw5eoANGLo More Microsoft Excel Videos: https://www.youtube.com/playlist?list=PLsYjn_fAfG42S1JmTFr7B5eTQRvm5w3sF Visit my Microsoft Excel Blog: https://chrismenardtraining.com/training/excel-blog #xlookup #excel #exceltutorial And make sure you subscribe to my channel! -- EQUIPMENT USED --------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 -- SOFTWARE USED --------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week! poAdZpw7oL8 |
| Category | Howto & Style |
| Tags | xlookup vs vlookup | two-way xlookup | how to use xlookup function | xlookup multiple criteria | xlookup two criteria | nested xlookup function | excel xlookup tutorial | how to user the xlookup function | excel nested lookup tutorial | chris menard | xlookup in excel | xlookup vs vlookup in excel | microsoft excel | xlookup tutorial | advanced excel tricks | excel online course | vlookup in excel | office 365 | excel xlookup formula | nested xlookup | excel xlookup |
