Vlookup Trick for multiple columns

[sancasteabro]

Love the clearly and the patience you explain
Keep doing a good job

[kw]

Omg!!! Thank you! Im working on a MAJOR project and have been crying my eyes out and wakingup out of my sleep!

[misterwill]

Excellent😮I had no idea this capability existed without complex formulas.

[nishanthh]

What if one is using Excel 2019? Since sequence function is available in 365 and newer versions

[gopigk]

Thank you, it's amazing.could you pls tell how to write vlookup for multiple columns in a single formula, which are not side by side

[deepakkt]

I want a detail video and shortcuts for vlookups as daily I have to work with large amount of data downloaded from dump, gone through shortcut video on multiple it's not working

[AmitSharma-tidh]

You can also do that by typing{2, 3, 4} in place of sequence.🙏

[oludareclement]

Nice one. thank you so much. please, how did you filter the name column alone?

[Vivekarun]

How do we use the same formula if the data contains multiple rows?

[Lil-ymsn]

Thank you, can you advice if anuj has two names with different values? I want when I type anuj in search box the result come with two rows . What formula I add my friend?

[sickswan]

Is there a way to do this but with multiple drop downs say drop-down one is a job drop down 2 is an operation then it auto populates time and setup?

[obscene]

What if I'm trying to do a partial match with hundreds of potential partial matches? I have a long list of partial strings in $K$28:$K$400, and I want to see if any of those cells are a partial match to $D5. Been searching online all week but cant find anything? Any suggestions?

[jenalynbesenio]

What is the alternative in sequence function? I'm currently using MS Excel 2019

[GetAmazed]

Match function would be much easier right?

[vishnunair]

Hi sir thats great one wht if the header are not in sequence like chemistry on 3rd and maths in 1st column will this work

[concernedhuman]

You have just made my report creation easy

PS: I used this for fetching 30 columns 😂😂

[twistttcreater]

Hello sir in the data middle one like 03/06/2023 Other data then it's can't be use then your formula will be failed

[sabanjohnkervin]

How to do that filtered names? Like when you click it, there's several names to choose from?

[aboiyumkhaibam]

How did u apply that switch option, can u plz tell me sir

[kalpeshpanchal]

It is a woking horizontal what about i have vertical. If I need to vlookup not only against 1 name but 10 name ? What should I change in the same formula?