XLOOKUP In Excel | What XLOOKUP Can Do For You | No More VLOOKUP

Published: 28 July 2020
on channel: Techdreamer

318

No more VLOOKUP?
No more HLOOKUP?
No more INDEX MATCH?
The NEW Excel XLOOKUP Function is here to stay
Discover how XLOOKUP can solve your Excel lookup problems.

DOWNLOAD FILE: https://drive.google.com/file/d/178WP...

What is XLOOKUP?
If you need to lookup a value on another Excel sheet or table, you can use the XLOOKUP function. Here are some of its features:

1. XLOOKUP can lookup values to the left OR right-hand side of the lookup range.
2.XLOOKUP looks for an exact match by default (you can change it if you like)
3.Use XLOOKUP to look for the next smallest value or the next largest value (approximate or close match)
4.XLOOKUP can do vertical AND horizontal lookups
5. XLOOKUP can find the first match or the last match (reverse lookup)
And guess what? XLOOKUP can also be combined with another XLOOKUP to lookup values inside a matrix - which means XLOOKUP can replace INDEX & MATCH formulas too!

Watch video XLOOKUP In Excel | What XLOOKUP Can Do For You | No More VLOOKUP online without registration, duration hours minute second in high quality. This video was added by user Techdreamer 28 July 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 318 once and liked it 69 people.

355,604

2.8K