Surprise your BOSS with this rarely used VLOOKUP Trick | Video 49

In a lot of cases, we use VLOOKUP to find exact matches, based on some kind of unique id. But there are many situations where we can perform VLOOKUP using Approximate Match. A classic case is using VLOOKUP to find a Grade for the students where marks are provided.

Suppose we are provided with Test scores of students and have been asked to find the grades for each student based on different slabs of scores. In such cases, we generally use nested IF and the formula goes too long.

In this video, I will share you with an awesome VLOOKUP trick that will replace nested IF. This trick is rarely used by us.

Picture Credit:

Please subscribe to our channel and enable the notification by pressing the bell button. Please also share this channel with your network. It will keep us motivated to create more tutorials for you all.

Share, Support, Subscribe!!!

Subscribe:
Youtube:
Twitter:
Facebook:
LinkedIn: linkedin.com/company/future-in-hands
Google Plus:

#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice

future in hands,vivekananda sinha,microsoft excel,vlookup,vlookup function,excel tips and tricks,tips,tricks,excel tricks,excel training,functions,excel function,excel formula,vlookup formula,vlookup with approximate match,vlookup with true,nested if,calculate grade,replace nested if in excel,