you are viewing a single comment's thread
view the rest of the comments
[–] 2 points 4 months ago (3 children)

Vlookup

Please use xlookup instead.

Forget about lookup, vlookup, hlook-up or index(match()).

Only use xlookup.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 1 point 4 months ago* (2 children)

    No place I have ever worked has had a version of excel with xlookup, so I can't really comment on it. Im not on 365 or a newer desktop version. We are on Office 2019, as I suspect many offices still are.

  • source
  • parent
  • hideshow 2 child comments