Excel Vlookup to get Non-Exact Match

Vlookup is most frequently used to find 'exact' match..., but it can also be used to find an approximate match or Non-Exact

In this video, I'd like to show you how to use you can apply this feature in day to day life, in situation whereby you need to create an automated classification dashboard.

Of course, any thing that you can do with Vlookup, you can also do with XLookup.
So, I will also show you how you can do something similar with Xlookup.

Time Stamps:
00:00 Vlookup
01:31 Automated Classification example
02:56 3 steps
03:10 Automated Classification using Vlookup with a twist
08:58 Automated Classification using Xlookup
09:47 Conclusion

Kind regards,
Isabella Susilowati.

#Lighthouseanalytix
#Excel

LA12