Learn how to get VLOOKUP to return multiple columns or a range of columns in Google Sheets. #vlookup #googlesheets #tutorial
Пікірлер: 81
@KinellUK4 жыл бұрын
Fantastic video! Never used sequence function before and combining it with vlookup is a stroke of genius 🙂 Thank you!
@muwagamicheal83174 жыл бұрын
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.
@LGTVBA332 жыл бұрын
he is so on point here.
@ashkanahmadi4 жыл бұрын
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.
@Raidon884 жыл бұрын
Great stuff, never thought about using a VLOOKUP like this before. Thanks for the helpful vid!
@Itsndy2 жыл бұрын
This is such fantastic material! Saved me from going into the pits of a million formulas to achieve one thing!
@nisargagza3 жыл бұрын
Superb..,😘🤗🤗
@madhavtamse9311 Жыл бұрын
Thank you, Great vedio, very much useful
@arunkumarsharma64063 жыл бұрын
Terrific, I have really been a fan of yours video very helpful thanks hundred thousand million times
@ExcelGoogleSheets3 жыл бұрын
Great to hear!
@user-nq1yt6vs6o10 ай бұрын
This really helped me. Thanks!!
@carlosanaya28892 жыл бұрын
Simply awesome. Thanks for sharing this.
@ExcelGoogleSheets2 жыл бұрын
:)
@JanaeMcKague Жыл бұрын
This was super helpful! You explained things so well. I am quite a beginner, so I appreciate the tutorial
3 жыл бұрын
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.
@Horselife7452 жыл бұрын
thank u, we use also "\" in Russian version
@Romariowll5 ай бұрын
Brazil... dont WORK (\) (;) (,)... Only brings the first result.
@TahmidShekh4 жыл бұрын
thanks, Share this tips
@cavanshirhuseynov59953 жыл бұрын
This is really so great. Thank you for doing this!
@jhonirosales12574 жыл бұрын
Wow
@md.nasirshikder38852 жыл бұрын
Thank you very much. It helped me save a lot of my time.
@mwebb4004 жыл бұрын
This is Extremely Helpful! Thank you!!
@JohnBGood13 жыл бұрын
Just amazing!
@paulloup52104 жыл бұрын
Excellent Video !! Thank you very much
@aahanavikram074 жыл бұрын
Always a lot to learn.. Thanks for your guidance 🙂
@bocobox4 жыл бұрын
I got to tell you this. you are an artist!!
@marksawesomeadventures2 жыл бұрын
You're a NINJA! :D
@MohitHarjai4 жыл бұрын
What a great use of sequence function... Keep it up 👍
@thejordanschwann11 ай бұрын
A god amongst men.
@paulhitchman23122 жыл бұрын
Very helpful -thank you!
@bradleylancaster1014 жыл бұрын
Exactly what i am looking for thanks so much!
@tanveerhussain38814 жыл бұрын
Dear teacher thanks with love
@findthetruth30214 жыл бұрын
You are amazing ✌️👌✌️👌✌️👌✌️
@marcosrs754 жыл бұрын
Excellent! Just improve my 12-column vlookup main sheet :)
@lazalazarevic61924 жыл бұрын
Lovely! Thanks man.
@tinedriessen24773 жыл бұрын
mind. blown.
@dylanmeyers44364 жыл бұрын
Thank you! Your vids are fantastic :)
@hoiyinwan82334 жыл бұрын
Amazing, thank you so much!!
@lpanebr4 жыл бұрын
Ow my God!!!!! Thank you!!!
@dsky66894 жыл бұрын
Спасибо! 💪🏼
@vaibhavoswal55904 жыл бұрын
You're fuckin awesome. Keep up the great work ♥️
@tibolefevre4 жыл бұрын
Impressive...
@johnr.7724 жыл бұрын
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.
@pichit.raetai4 жыл бұрын
I am google sheet FC , ^_^ thank you
@clematique4 жыл бұрын
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!
@ExcelGoogleSheets4 жыл бұрын
kzbin.info/www/bejne/opvZc2WXp6imhLM
@clematique4 жыл бұрын
@@ExcelGoogleSheets Thanks 🙏 Sorry about that I guess I asked you the same question that everyone 😅Anyway, this is perfect, thanks again !
@irahulshekhawat7 ай бұрын
Hey, the array doesn't work in MS 365 while merging the sequence functions.
@SubscribersThunai4 жыл бұрын
Hi sir, Will this Array method saves the formula processing time when we have lot many rows, comparing to put formula for all rows.
@beauchicbeautyservices32943 жыл бұрын
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
@rumki123sanyal3 Жыл бұрын
Do we have gsheet application which we can install in our system and work
@fatimagajia26633 жыл бұрын
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!
@ExcelGoogleSheets3 жыл бұрын
Try FLATTEN function
@nukenatal61683 жыл бұрын
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?
@nukenatal61683 жыл бұрын
And the Name column contains Duplicates, so when I use vlookup it only gets me the first row
@twinkleTipsAndFacts4 жыл бұрын
Please put link for the copy of sample sheet that you worked on
@tompenny93523 жыл бұрын
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...
@ExcelGoogleSheets3 жыл бұрын
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.
@dianlaksmanaanindita95764 жыл бұрын
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?
@dianlaksmanaanindita95764 жыл бұрын
OK i got it... thanks
@biggynbp3 жыл бұрын
can vlookup be used to move data that is updated automatically?
@ExcelGoogleSheets3 жыл бұрын
Depends on what you mean by "move", but probably not.
@ConsulthinkProgrammer4 жыл бұрын
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 Thanks Sir. I perfectly understood now :) I even can do this kzbin.info/www/bejne/mKCWgIigm76Mj6M Thanks a lot 😊
@haroonshehzad67913 жыл бұрын
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.
@ExcelGoogleSheets3 жыл бұрын
kzbin.info/www/bejne/laKolGt5esyIopY
@haroonshehzad67913 жыл бұрын
@@ExcelGoogleSheets Thank you soooooooooooooooooo much bro
@mehulpatel63332 жыл бұрын
Hey, great video! However, it is not working for me. It is only returning 1 column. Can you please help?
@ExcelGoogleSheets2 жыл бұрын
Which version of Excel?
@mehulpatel63332 жыл бұрын
@@ExcelGoogleSheets I am using it on google sheets
@ExcelGoogleSheets2 жыл бұрын
did you use ARRAYFORMULA() around it?
@ExcelGoogleSheets2 жыл бұрын
What's your formula?
@mehulpatel63332 жыл бұрын
@@ExcelGoogleSheets hey thank you so much for pointing it out. Yes, it is working. Thanks a lot! Keep making such awesome videos!!
@tastetwistbymemia Жыл бұрын
does this work anymore?
@ExcelGoogleSheets Жыл бұрын
Yes
@sungguhsetianto89543 жыл бұрын
why the result not to the left, but to go down..?thnks
@ExcelGoogleSheets3 жыл бұрын
use \ in your case
@ExcelGoogleSheets3 жыл бұрын
kzbin.info/www/bejne/opvZc2WXp6imhLM
@sungguhsetianto89543 жыл бұрын
@@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..