VLOOKUP - Return Multiple Columns - Google Sheets

[@ashkanahmadi]

Thank you so much. I had to copy paste the formula one by one to get different columns a few days ago. This is a huge time saver.

[@KinellUK]

Fantastic video! Never used sequence function before and combining it with vlookup is a stroke of genius 🙂 Thank you!

[@nisargagza]

Superb..,😘🤗🤗

[@muwagamicheal8317]

This the best video on his subject i have ever watched on youtube. Thank you very much. People like make life on the internet more meaningful.

[@LGTVBA33]

he is so on point here.

[@madhavtamse9311]

Thank you, Great vedio, very much useful

[@carlosanaya2889]

Simply awesome. Thanks for sharing this.

[@ExcelGoogleSheets]

:)

[@Itsndy]

This is such fantastic material! Saved me from going into the pits of a million formulas to achieve one thing!

[@Raidon88]

Great stuff, never thought about using a VLOOKUP like this before. Thanks for the helpful vid!

[@zoegarcia8470]

This is EXACTLY what I needed!! Thank you for the amazing explanation 💯

[@ExcelGoogleSheets]

😊

[@arunkumarsharma6406]

Terrific, I have really been a fan of yours video very helpful thanks hundred thousand million times

[@ExcelGoogleSheets]

Great to hear!

[@JanaeMcKague]

This was super helpful! You explained things so well. I am quite a beginner, so I appreciate the tutorial

Thank You , very useful On Turkish verison of google sheets like you said instead of "," we use ";" and to select different columns we use "\" between columns.

[@Horselife745]

thank u, we use also "\" in Russian version

[@Romariowll]

Brazil... dont WORK (\) (;) (,)... Only brings the first result.

[@cavanshirhuseynov5995]

This is really so great. Thank you for doing this!

[@LucyGathii-f8q]

This really helped me. Thanks!!

[@bocobox]

I got to tell you this. you are an artist!!

[@TahmidShekh]

thanks, Share this tips

[@findthetruth3021]

You are amazing ✌️👌✌️👌✌️👌✌️

[@md.nasirshikder3885]

Thank you very much. It helped me save a lot of my time.

[@aahanavikram07]

Always a lot to learn.. Thanks for your guidance 🙂

[@paulloup5210]

Excellent Video !! Thank you very much

[@MohitHarjai]

What a great use of sequence function... Keep it up 👍

[@mwebb400]

This is Extremely Helpful! Thank you!!

[@JohnBGood1]

Just amazing!

[@paulhitchman2312]

Very helpful -thank you!

[@marksawesomeadventures]

You're a NINJA! :D

[@johnr.772]

Your Videos have been really Helpful. Do you have a work-around for this formula if you have combined cells? I have columns A,B,C combined into 1 cell, this formula tried to put the results for 2 & 3 in the combined cells.

[@tanveerhussain3881]

Dear teacher thanks with love

[@marcosrs75]

Excellent! Just improve my 12-column vlookup main sheet :)

[@SubscribersThunai]

Hi sir, Will this Array method saves the formula processing time when we have lot many rows, comparing to put formula for all rows.

[@rumki123sanyal3]

Do we have gsheet application which we can install in our system and work

[@ERESTunes]

Hey, the array doesn't work in MS 365 while merging the sequence functions.

[@bradleylancaster101]

Exactly what i am looking for thanks so much!

[@clematique]

Wow Awesome !! Thanks Although I've got a question after having tried on my document. The results appear in lines and not in columns, do you have any idea why? Thanks!

[@ExcelGoogleSheets]

kzbin.info/www/bejne/opvZc2WXp6imhLM

[@clematique]

@@ExcelGoogleSheets Thanks 🙏 Sorry about that I guess I asked you the same question that everyone 😅Anyway, this is perfect, thanks again !

[@beauchicbeautyservices3294]

Hi, this video is very helpful, but i have encountered an issue. Let's take yours as example: For the stock number, i have change it to dropdown list, the list data from "Merge Data Source". so by right in sheet "Merge Data", if i choose the stock number, it should return the value i am looking for. But in this case, in "Merge Data" cell:B2, i selected the 4953-66-590, it should return the "running shoes" from "Merge Data Source", but it return the value "sneaker Boot", which is wrong result. and in "Merge Data" cell:B3 i selected the 5133-23-374, it should return the "Training Shoes", but it return the "Running Shoes" instead. Please advise where goes wrong and what should i do? Thank you

[@tompenny9352]

When you got rid of the iferror you were back to N/A. I hope you'd show a better way to return blanks. my tables are very big and the iferror makes it slow...

[@ExcelGoogleSheets]

Are your tables actually very big or do you have a lot of blank rows below your data? If you have a lot of blank rows delete them. Most commonly I see spreadsheets where there are thousands of blanks rows below the data, which is where it gets slow.

[@dylanmeyers4436]

Thank you! Your vids are fantastic :)

[@lazalazarevic6192]

Lovely! Thanks man.

[@nukenatal6168]

Hi I have a question. I have a table which contains in order; Date, Name and 21 columns of Numbers(Percentage). What I want to do is to find the total percentage that corresponds with a Name and Date from - Date to. Can you help me please?

[@nukenatal6168]

And the Name column contains Duplicates, so when I use vlookup it only gets me the first row

[@dianlaksmanaanindita9576]

hi i got a problem because when i try to use arrayformula there is erorr with mention that "Array Result was not expanded because it would overwrite data in the cell after" what is the solution?

[@dianlaksmanaanindita9576]

OK i got it... thanks

[@twinkleTipsAndFacts]

Please put link for the copy of sample sheet that you worked on

[@hoiyinwan8233]

Amazing, thank you so much!!

[@jhonirosales1257]

Wow

[@vaibhavoswal5590]

You're fuckin awesome. Keep up the great work ♥️

[@tibolefevre]

Impressive...

[@biggynbp]

can vlookup be used to move data that is updated automatically?

[@ExcelGoogleSheets]

Depends on what you mean by "move", but probably not.

[@haroonshehzad6791]

Hi there I need your help to deal with a problem which is just making a barrier for me, I look up for one purchase order which is having different invoices, I just get the first invoice number, if you want i can give you the exact picture of my problem. I would be grateful if you can help me to solve it.

[@ExcelGoogleSheets]

kzbin.info/www/bejne/laKolGt5esyIopY

[@haroonshehzad6791]

@@ExcelGoogleSheets Thank you soooooooooooooooooo much bro

[@fatimagajia2663]

Hiya, I find your series of videos soo helpful i am always referring to them as you not only explain step by step, you also explain why things work the way it does. However i am stuck! I have a row of 9 columns : Column 1 has numbers, Column 2 has numbers, Column 3 has dates,Column 4 has numbers, Column 5 has numbers, Column 6 has dates, Column 7 has numbers, Column 8 has numbers, Column 9 has dates. I want to to list numbers from Column three different columns into one column. The data has to come from Columns 1,4,7 WITHOUT adding the numbers.Please HEELLLP!

[@ExcelGoogleSheets]

Try FLATTEN function

[@lpanebr]

Ow my God!!!!! Thank you!!!

[@dsky6689]

Спасибо! 💪🏼

[@tinedriessen2477]

mind. blown.

[@pichit.raetai]

I am google sheet FC , ^_^ thank you

[@ConsulthinkProgrammer]

Pardon Sir. I tried to write the formula like you did: ={SEQUENCE(1;3;2);SEQUENCE(1;3;6)} But my result: 2 3 4 6 7 8 It has to be one raw right, not two... Can you help to explain what happened about this situation?

[@ExcelGoogleSheets]

={SEQUENCE(1;3;2)\SEQUENCE(1;3;6)} kzbin.info/www/bejne/opvZc2WXp6imhLM

[@ConsulthinkProgrammer]

@@ExcelGoogleSheets Thanks Sir. I perfectly understood now :) I even can do this kzbin.info/www/bejne/mKCWgIigm76Mj6M Thanks a lot 😊

[@mehulpatel6333]

Hey, great video! However, it is not working for me. It is only returning 1 column. Can you please help?

[@ExcelGoogleSheets]

Which version of Excel?

[@mehulpatel6333]

@@ExcelGoogleSheets I am using it on google sheets

[@ExcelGoogleSheets]

did you use ARRAYFORMULA() around it?

[@ExcelGoogleSheets]

What's your formula?

[@mehulpatel6333]

@@ExcelGoogleSheets hey thank you so much for pointing it out. Yes, it is working. Thanks a lot! Keep making such awesome videos!!

[@sungguhsetianto8954]

why the result not to the left, but to go down..?thnks

[@ExcelGoogleSheets]

use \ in your case

[@ExcelGoogleSheets]

kzbin.info/www/bejne/opvZc2WXp6imhLM

[@sungguhsetianto8954]

@@ExcelGoogleSheets thank you so much..i'ts work..my problem is, my acount goole languange that use " ; " as separator formula, and yeahh with "\" that's work for me..thanks..

[@tastetwistbymemia]

does this work anymore?

[@ExcelGoogleSheets]

Yes

[@thejordanschwann]

A god amongst men.