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.
To understand it, you should see Result table tagged below.
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