Tricks to use in Vlookup - Excel tips and tricks 2021

#exceltipsandtricks #vlookup #eliminateerror

Watch the above video....

We have shown simple tricks which can be used to eliminate error and save time while using vlookup in #excel, this smart technique will help everyone in their professional life.

1. Multi-column Vlookup - We generally use vlookup multiple times if we have to get the lookup value in multiple columns. This video will show you simple technique 2. Error due to Space - If there is space added to lookup value then we get error. You can get rid of this error easily after watching this video 3. Vlookup output for lookup value contains specific characters in lookup table

00:00 Intro about Vlookup

00:40 Trick-1 : Multi-column Vlookup

01:41 Trick-2 : Eliminating error due to space

03:36 Trick-3 : Output for incomplete vlookup value

04:34 Conclusion

If you have any queries, please post it in comment section.