#shorts | VLOOKUP with MATCH in Excel

#shorts
#vlookup
#vlookupformula

by using VLOOKUP with MATCH you can lookup your data in a dynamic way. MATCH functions provide column index number to the VLOOKUP function based on your data header.

[ajaysakpal]

Usefull ! Simple and on point without unnecessary talk ..

[yggexjz]

Gazab bhai itna aasan koi nhi batata sab gyan dene lagte h 😂 Thank you to crack this in 30 sec. 😊😊

[RKSiNgH-mxcm]

Great trick.... I am searching this easy way of pulling data. 😊

[marketwatch]

Thank you boss...pahali baar sahi Vlookup Sikh liya❤

Achha hua comment padh liya, $ manually laga raha tha, lo ab vo bhi pata chala 😂😂😂

[WaqarKhan-foyl]

Thank you, sir! Was pissed off as couldn't find the exact value for bigger table. Thanks a ton

[roktavhkumarsarmah]

Finally learned vlookup with full clarity ❤❤ concept cleared fully ..thank you 😊

[nazim]

tried 20times show error
but finally i learn thank you so much bro...

[rohit__g]

Guys these trick is amazing but let me tell you if you are using 2021 version or 365 days of excel version just use vlookup function you don't meed to use match function just givr your "Lookup value, table array, in the column index number use curly bracket like {2, 3, 4}, 0 ctrl+ enter you will also get the same result it depends upon you how you are using

[dipenderkumar]

Sir ji aap ne tho problem solve kardi meri thank you

[kenczqe]

Amazing exactly what i was looking for I'll try it, thank you

[manojpatwa]

Great sir maja aa gaya shuru me babut problem aai fir comment pad kr solution mil gaya usme funda f4 press krne ka hai. Please aap ek video me f4 ko acche se clear kr dijiye.

[rrajkumar]

Hi...Dear brother...Thank you so mush for this video...God bless you and your family

[prabujayk]

Thank u.. i got it.. formula its working 👍

[raks...]

If you freeze $ sign comes before F10 like $F10, but if I freeze by function f4 it shows $F$10 and at the end it shows REF

[abhishekverma]

First F4 press three times and after that one time and after match formula F4 press f4 two times after that F4 press one time.. It will work 100%

[garv]

You used word freeze the column, didn’t get how to freeze the column. Please help