<

Querying Excel worksheets with the Xlookup function

Posted on
3,211 Points
11 Views
2 Endorsements
Last Modified:
Published
Experience Level: Intermediate
9:09
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
The Xlookup function introduced in Excel 2019 replaces the older Vlookup and Hlookup functions. It's easier to use and more intuitive.

Get the data file:
flisser.com/download/xlookup.xlsx

Take the full course:
www.udemy.com/excel90min
2
Author:Bob Flisser
2 Comments
LVL 34

Comment

by:Jacques Geday
Excellent work and video Bob !!!
1
LVL 14

Author Comment

by:Bob Flisser
Thank you!
0
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Encryption.
Have you ever wanted to make your MS Excel spreadsheet more easy to follow?  Here is one way to do just that.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month