Excel Xlookup - exciting stuff

[MOBB]

Anyone that uses vlookup and knows it’s issues and limitations should be excited by this :-)

https://techcommunity.microsoft.com/t5/Excel-Blog/...

[AndrewEH1]

Excited - but won't see that on my work PC for sometime even after it's release

[paulrockliffe]

I looks like a good improvement, but if you're doing Lookups in Excel in any version after 2013, the best option is to add your tables to the Data Model so you can define the relationships between them. You can then use all your tables together in a Pivot Table without having to define relationships (which is what your VLOOKUP is doing) at individual row/column level.

[mmm-five]

Looks like it will replace some simple INDEX/MATCH formulae too.

[CaptainSlow]

Some of the statements on that link are incorrect eg the section about vlookups selecting approximate matches.

All the benefits of the xlookup are currently achieved using simple alternatives.

[MOBB]

I agree for experienced excel users but this looks a piece of piss for people to learn vs index/match etc