Offset with Match function Excel

Tips-&-Tricks Mar 27, 2019

How to retrieve back side value using #offset Function?

Back side value means left side data of unique column. For most users it's a tedious job to work with Offset function and even then if interviewer ask you on interview to get data from left side of unique field using offset function, most of us get totally lost.

To get the solution you can use offset with match.

Let's use Master_Table to get the data from.

Image 2 - Master Table

To understand it, you should see Result table tagged below.

Image 2 - Result Table (Offset with Match)


Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be excel expert, connect us on:

9599408486 / 8929231250

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.