Excel’s Newest Function XLOOKUP

VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features such as what to do if it doesn’t find a match and also can look either to the left of the lookup value or above, something not possible with the other functions mentioned.

If you want to see how it works check out the video below.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, excel function, Microsoft Office and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

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 )

Google photo

You are commenting using your Google 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