Queries, VLookup, XLookup & Co.

Find information and match values in Excel 365 and 2021

Virtual Voice Sample

Failed to add items

Sorry, we are unable to add the item because your shopping cart is already at capacity.

Add to Cart failed.

Please try again later

Add to Wish List failed.

Please try again later

Remove from wishlist failed.

Please try again later

Adding to library failed

Please try again

Follow podcast failed

Please try again

Unfollow podcast failed

Please try again

Audible Standard 30-day free trial

Try Standard free

Select 1 audiobook a month from our entire collection of titles.

Yours as long as you’re a member.

Get unlimited access to bingeable podcasts.

Standard auto renews for $8.99 a month after 30 days. Cancel anytime.

Queries, VLookup, XLookup & Co.

By: Ina Koys

Narrated by: Virtual Voice

Try Standard free

$8.99 a month after 30 days. Cancel anytime.

Buy for $3.99

This title uses virtual voice narration

Virtual voice is computer-generated narration for audiobooks.

Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUP() which are often heard of, but not really mastered. But there are more options like the Advanced filter, IF(), Database functions and the new, cutting-edge ones like SWITCH() and the brand new, very convenient XLOOKUP().

All are explained with examples and their specific benefits and downsides.

No reviews yet