VLOOKUP - Return Multiple Columns

VLOOKUP - Return Multiple Columns - Google Sheets

Рет қаралды 66,631

Learn Google Sheets & Excel Spreadsheets

4 жыл бұрын

Learn how to get VLOOKUP to return multiple columns or a range of columns in Google Sheets.
#vlookup #googlesheets #tutorial

Пікірлер: 81

@KinellUK 4 жыл бұрын

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

@ashkanahmadi 4 жыл бұрын

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.

@Raidon88 4 жыл бұрын

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

@Itsndy 2 жыл бұрын

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

@muwagamicheal8317 4 жыл бұрын

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 2 жыл бұрын

he is so on point here.

@JanaeMcKague Жыл бұрын

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

@mwebb400 4 жыл бұрын

This is Extremely Helpful! Thank you!!

@MohitHarjai 4 жыл бұрын

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

@aahanavikram07 4 жыл бұрын

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

@cavanshirhuseynov5995 3 жыл бұрын

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

@johnr.772 4 жыл бұрын

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.

@bocobox 4 жыл бұрын

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

@SubscribersThunai 4 жыл бұрын

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

@nisargagza 3 жыл бұрын

Superb..,😘🤗🤗

@dylanmeyers4436 4 жыл бұрын

Thank you! Your vids are fantastic :)

@bradleylancaster101 4 жыл бұрын

Exactly what i am looking for thanks so much!

@lazalazarevic6192 4 жыл бұрын

Lovely! Thanks man.

@hoiyinwan8233 4 жыл бұрын

Amazing, thank you so much!!

@user-nq1yt6vs6o 9 ай бұрын

This really helped me. Thanks!!

@paulloup5210 4 жыл бұрын

Excellent Video !! Thank you very much

@JohnBGood1 3 жыл бұрын

Just amazing!

@madhavtamse9311 Жыл бұрын

Thank you, Great vedio, very much useful

@paulhitchman2312 2 жыл бұрын

Very helpful -thank you!

@arunkumarsharma6406 3 жыл бұрын

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

@ExcelGoogleSheets 3 жыл бұрын

Great to hear!

@marcosrs75 4 жыл бұрын

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

@carlosanaya2889 2 жыл бұрын

Simply awesome. Thanks for sharing this.

@ExcelGoogleSheets 2 жыл бұрын

@md.nasirshikder3885 2 жыл бұрын

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

@TahmidShekh 4 жыл бұрын

thanks, Share this tips

@findthetruth3021 4 жыл бұрын

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

@lpanebr 4 жыл бұрын

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

@beauchicbeautyservices3294 3 жыл бұрын

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

@marksawesomeadventures 2 жыл бұрын

You're a NINJA! :D

@tanveerhussain3881 4 жыл бұрын

Dear teacher thanks with love

@dsky6689 4 жыл бұрын

Спасибо! 💪🏼

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.

@Horselife745 2 жыл бұрын

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

@Romariowll 4 ай бұрын

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

@vaibhavoswal5590 4 жыл бұрын

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

@clematique 4 жыл бұрын

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 4 жыл бұрын

kzfaq.info/get/bejne/otCmdZWS16nXfoU.html

@clematique 4 жыл бұрын

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

@irahulshekhawat 6 ай бұрын

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

@twinkleTipsAndFacts 4 жыл бұрын

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

@thejordanschwann 10 ай бұрын

A god amongst men.

@jhonirosales1257 4 жыл бұрын

Wow

@tinedriessen2477 3 жыл бұрын

mind. blown.

@pichit.raetai 4 жыл бұрын

I am google sheet FC , ^_^ thank you

@rumki123sanyal3 Жыл бұрын

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

@nukenatal6168 3 жыл бұрын

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 3 жыл бұрын

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

@tompenny9352 3 жыл бұрын

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 3 жыл бұрын

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.

@dianlaksmanaanindita9576 4 жыл бұрын

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 4 жыл бұрын

OK i got it... thanks

@fatimagajia2663 3 жыл бұрын

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 3 жыл бұрын

Try FLATTEN function

@biggynbp 3 жыл бұрын

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

@ExcelGoogleSheets 3 жыл бұрын

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

@tibolefevre 4 жыл бұрын

Impressive...

@haroonshehzad6791 3 жыл бұрын

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 3 жыл бұрын

kzfaq.info/get/bejne/ldd1lpt0qs25nGg.html

@haroonshehzad6791 3 жыл бұрын

@@ExcelGoogleSheets Thank you soooooooooooooooooo much bro

@tastetwistbymemia Жыл бұрын

does this work anymore?

@ExcelGoogleSheets Жыл бұрын

Yes

@ConsulthinkProgrammer 4 жыл бұрын

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 4 жыл бұрын

={SEQUENCE(1;3;2)\SEQUENCE(1;3;6)} kzfaq.info/get/bejne/otCmdZWS16nXfoU.html

@ConsulthinkProgrammer 3 жыл бұрын

@@ExcelGoogleSheets Thanks Sir. I perfectly understood now :) I even can do this kzfaq.info/get/bejne/mNVjgriby7-9iXU.html Thanks a lot 😊

@sungguhsetianto8954 3 жыл бұрын

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

@ExcelGoogleSheets 3 жыл бұрын

use \ in your case

@ExcelGoogleSheets 3 жыл бұрын

kzfaq.info/get/bejne/otCmdZWS16nXfoU.html

@sungguhsetianto8954 3 жыл бұрын

@@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..