News How to Use XLOOKUP in Excel: VLOOKUP on Steroids

[Admin]

The XLOOKUP function allows you to match data from one column with content from other columns or sheets.

How to Use XLOOKUP in Excel: VLOOKUP on Steroids : Read more

 

[hermitboy]

I've been looking around for detail on the match mode and search mode for a few days. This was helpful, thanks for posting it!

 

[AndrewJacksonZA]

This was... odd to see on a hardware site to say the least, but at least I learnt something!

 

[13thmonkey]

@admin we've had a few queries over the use of very large excel files, do we have the ability to understand if this is more efficient than vlookup or index(match)?

 

[emccormick]

https://github.com/Excel-DNA/XFunctions/releases/tag/v0.2-alpha