Skip main navigation

Approximate match with XLOOKUP

XLOOKUPs can also carry out approximate matches. Watch now as Paula Guilfoyle demonstrates.

Approximate match options in XLOOKUP adds a lot of flexibility to your lookup function.

Make sure you have downloaded the workbook and can carry out all of the steps shown in this video. The workbook can be found in step 1.4

Comment below

What are your main takeaways from this video?

This article is from the free online

Excel Skills to Make an Impression

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now