3 useful VLOOKUP tricks ✨ in one minute #Shorts

#shorts #vlookup

3 creative and useful VLOOKUP tricks in one minute.

1. Use * or ? as wild cards
2. Add up or average multiple columns by using them in column_number option like {3,4,5,6}
3. Deal with extra spaces by using TRIM on the lookup value

More on VLOOKUP
===============

[frenan]

Amazing Sum & Vlookup.... opens a new world of posibilities for me. Thanks.

[TimTheMusicMan]

Definitely one of the best Excel channels out there.

[fermion]

You are a true genius of excel .Highly appreciated. I have learnt so many things from you and will continue learning

[KDlima]

Sum & Vlookup one is very helpful. Sometime back I was searching for a similar issue and stumbled across vlookup and sum with offset. This can help us specify number of columns be summed up.

[matthewjensen]

The way that reports pull at work the Trim is a game changer!!

[srikrishnatatavarthy]

Yes, useful and simple trick on vlook up

[deepthireddy]

The most valuable use of a minute! Thanks for this!

[wayneedmondson]

Nice quick VLOOKUP lesson! Thanks Chandoo :)) Thumbs up!!

[bijalbhavsar]

the below formula will give an error if we simply press" enter" . since we have used an array function, we need to use "CTRL+Enter" to get the correct result.

[profha]

Interesting...
Never did vlookupsum....

This channel puts my 20 years of work experience to shame

Thanks Chandoo

[canirmalchoudhary]

I think for multiple column, we can use sequence formula

[rhonamocke]

Love this guy. I following him since way back in I think 2010

[panwspanialy]

These short videos are gold. Pure gold. THank you for this excellent work!

[santoshpv]

What !!!! I have been using vlook up for 20 years and I never knew any of these...You are too good!

[smcorner]

What is use of * in first illustration.

Anyone can help...

[ranjan]

Sir, I have a question other than this specific topic. If you can answer, I will be obliged. I have a single column(B) of data [price](let's say 2800 row i.e B1 to B2800) all are stacked datewise in A1:A2800. I want to take 4 rows serially(A1:A4) and make them 4 columns(Open, High, Low, Close), & continue the same for the total data points. Those 4 columns I will stack as High, Low, Open, Close, the one from A1:A4 with the highest value under High, lowest under low, A1 as Open, A4 as close. Is it possible?

[clivepetty]

Thanks for these, especially the use of trim in the formula

[shaikhshaibaz]

chandoo sir you should provide these data for practice

[thangaveluraj]

Superb, thanks a lot. Looking forward for such short and high content videos