xLookup Coming to Excel Near You!

Microsoft announced that they are adding a big brother to vLookup named xLookup.

The best things about xLookup: 1) it fixes some of the limitations of vLookup, 2) it is easy to understand and use, and 3) it replaces hLookup also.

Also, vLookup and hLookup are not going anyway, so if any of your colleagues struggle to learn new things, they can continue to use them as is.

See the Microsoft blog post here, which provides an easy animation on how it works. xLookup should be rolling out in the next couple of weeks.

Kind of surprised they didn’t name this iLookup; they probably wanted a letter that is later in the alphabet (x) to show the progress.

Oh, one other thing. ..Who uses hLookup? I never have.

Check out the Excel Basic Data Analytics series.

1 Comment

Filed under Audit

One response to “xLookup Coming to Excel Near You!

  1. John

    Excel insider program :( So you need to have a home, personal, or university office subscription. Otherwise it will be a while before it hits office pro. Definitely exciting news though.

    Liked by 1 person

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.