Hellow guys, Welcome to my website, and you are watching XLOOKUP - Excel's new awesome function by Chris Menard. and this vIdeo is uploaded by Chris Menard at 2019-09-01T09:56:39-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | XLOOKUP - Excel's new awesome function by Chris Menard |
| Video Uploader | Video From Chris Menard |
| Upload Date | This Video Uploaded At 01-09-2019 16:56:39 |
| Video Discription | XLOOKUP is the latest function for Microsoft Excel. It came out on August 28, 2019. If you like VLOOKUP and Index/Match, you are going to love the XLOOKUP function. There are over 450 functions in Excel. Rarely does a new function come out that is a game-changer, but XLOOKUP is a game-changer. NOTE: August 28, 2019: XLOOKUP is currently a beta feature, and only available to a portion of Office Insiders at this time. It is being optimized by Microsoft. When XLOOKUP is ready, Microsoft will release it to all Office Insiders, and Office 365 subscribers. If you have Office 2019, you will not get XLOOKUP. XLOOKUP has five arguments, but only three are required. The three required are 1) lookup_value: What you are looking for 2) lookup_array: Where to find it 3) return_array: What to return The two optional requirements for XLOOKUP are Match Mode and Search Mode. They are the 4th and 5th arguments respectively. Six features mentioned on Microsoft's tech page regarding VLOOKUP limitations: 1) Defaults to an “approximate” match 2) Does not support column insertions/deletions 3) Cannot search from the back 4) Cannot look to the left 5) Cannot search for next larger item 6) References more cells than necessary https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376 What is the future of VLOOKUP and HLOOKUP? Both will still stay around. XLOOKUP is only for Office 365 users. Office 2019 and Office 2016 users will not have XLOOKUP. (Another reason to get on Office 365.) Chris Menard's blog post on XLOOKUP https://chrismenardtraining.com/post/xlookup-function-excel Other material XLOOKUP support site on Microsoft https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929?ui=en-US&rs=en-US&ad=US Chris Menard's Website: https://chrismenardtraining.com #xlookup #exceltutorial #excel 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! |
| Category | Howto & Style |
| Tags | xlookup | function | vlookup | index/match | xlookup function | new | office 365 | o365 | insiders | Microsoft | Excel | Look left | xlookup in excel | excel xlookup | xlookup explained | microsoft excel | xlookup vs vlookup | xlookup vs index match | vlookup in excel | vlookup function in excel 2016 | excel tutorial | vlookup tutorial | microsoft excel tutorials | xlookup tutorial | vlookup function | xlookup features | xlookup examples | excel approximate match | look to the left | excel search from the back |
