<

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:gowflow
Excellent work and video Bob !!!
1
LVL 10

Author Comment

by:Bob Flisser
Thank you!
0
Recently I have answered a question on how to distribute hours evenly between two dates. I thought this isn't that difficult to do that in Excel with formula, but what I see from this question, it could be applied to other similar scenarios. So, let…
This document presents the Modern Active Directory project, which aims to bring a more modern view on your Active Directory, whether to view key indicators or to perform advanced searches in a simple way. With this PowerShell module that accesses …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month