Jump to content

Providing independent coverage of the Minnesota Twins.
Photo

Buh-buh, vlookup (kinda)

  • Please log in to reply
No replies to this topic

#1 Doomtints

Doomtints

    Minnesota Twins

  • Member
  • 3,688 posts

Posted 01 September 2019 - 06:40 PM

vlookup is something you will see as a minimum requisite for most Excel jobs, but if you really push Excel you gave up on vlookup and moved over to index/match instead (someone should tell the job recruiters).

 

Microsoft is adding xlookup, which looks like it works like index/match does and Microsoft claims it's faster. Time will tell if that's true (it's almost certainly faster than vlookup).

 

The drawback: Only Office 365 will support xlookup, which means many of us will stay away from it because so many people (and businesses) out there won't be able to use our workbooks properly if we use it.

 

https://techcommunit...KUP/ba-p/811376

Twins Manifesto: Build for .500, hope for more.