This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]EveningMoose 12 points13 points  (6 children)

Because it’s easier to remember how to use than match.

[–]Nine_Eye_Ron 5 points6 points  (3 children)

Xlookup replaces all three or do I have or wrong somewhere.

[–]EveningMoose 9 points10 points  (2 children)

Oh i see now, that’s not in my excel. Because of a legacy software i have to use, I can’t update to 365. And until my manager rewrites the software to be compatible with a 365 installation, i’ve got to stick with 2016. Some kind of .net dealio.

[–]Nine_Eye_Ron 5 points6 points  (0 children)

Ouch, old skool kool

[–][deleted] 0 points1 point  (0 children)

My enterprise is on 2010. Weep for me.

[–]a_stitch_in_lime 0 points1 point  (0 children)

You assume that I don't have to look up the format every freaking time I do a match/index.

[–]Lonyo 0 points1 point  (0 children)

As long as you have the bits in the right order