|
|||||
XLookup Function By Richard Rost 4 years ago How to use the XLookup function in Excel 365 XLookup is a newly added function to Microsoft Excel in 2019 for Microsoft 365 subscribers and is a powerful replacement for VLookup and HLookup. In this example, I'll show you how to look up employee pay rates for your time sheets. ClarificationIn the video I mention that XLOOKUP is available for Microsoft Excel 2019. My apologies, it is ONLY available for Microsoft 365 subscribers. I believe I read somewhere at the time it was released that they would be adding it to Excel 2019, but apparently it's only for subscribers. Sorry for the confusion. MembersThere is no Extended Cut for this video. LinksExcel Expert 11 Learn More!
Questions?Please feel free to post your questions or comments below. Thanks.
|
||||||||||||||||||
| |||
Keywords: TechHelp Excel XLookup PermaLink XLookup Function in Microsoft Excel |