Google Sheets - QUERY from Another Sheet, IMPORTRANGE, Use Multiple Tabs, Subquery Examples Tutorial 

Thank you!!!, I was banging my head against the wall previously because IMPORTRANGE wasn't working for importing multiple sheets into a single query, you sir are awesome!! thanks again

Your videos are the best. I have been able to build an entire database in multiple sheets because of your awesome tutorials. THANK YOU!

I don't have enough words to appreciate you putting out all this amazingly explained information for free on RU-vid... Thank you...!!!! Thank you....!!!!! Thank you....!!!

This was so helpful. Literally the only place I found such a clear answer. Great video

This entire series is amazingly helpful. It is THE definitive guide to using Sheets like a pro. Thank you!

This is amazing and your talent of explaining the steps inspires me!

Google should make you an official associate, there is a huge demand for resources for google sheet and your channel is an extremely valuable resource

This is what I have been looking for. Thank you very much. Easy to understand and follow.

Awesome my main man. Had a bit of panic at first not working but I had forgot the QUERY at the beginning. All great.

Thanks for the tutorial on using QUERY with IMPORTRANGE. Really helped me!

Thanks for all your tutoring. Your videos are just what I needed as I needed to brush up on my accounting reporting skills not utilised since I retired years ago. The software environment has changed a lot and the advantages of Google sheets offers as a way of communicating and collaborating is significant. I used to use Visual dBase which had an SQL like query language so the syntax is familiar. What was great about VdB was that you could input data in a user friendly form and see the code come out on a "Command Screen". It was a great way for a novice to write and learn to code. In addition you could copy and paste the code and incorporate into larger programs. Wouldn't it be great if Google Sheets could come up with something similar?

Thank you SO much - been having so much trouble sorting text data and this finally solved my problem at work!!

Wonderful! I knew there had to be a way to query from multiple sheets, I just didn't know about the bracket for the array.

Thank you so much! I have been able via your videos to minimize manual updates. Thanks again.

Sir, you are the Best, your videos have contributed too much in me gaining respect in my office

Greetings from Brazil. I would like to thank you for this serie, it was very helpful

You are a great teacher. These videos are super helpful.

I'm learning new tricks...This tricks also helpful for learning SQL queries..Thank you brad, very concise and clear..

Awesome tutorial! Loved it. Thanks for putting in such efforts to educate folks.

QUERIES ARE WONDERFUL!! I was wondering how to reference a series of cells from a different worksheet into a series of cells in a different worksheet without copy-pasting a formula a million times. This is the answer. You don't have to type it all out manually, just as expected. Thanks for these tutorials, I looked for google spreadsheet tutorials and this series is what I came across, which is helpful.

You all are awesome. Thank you for the great videos you create and share!

Thank you for your sharing. I learn a lot from this video.

Wow amazed.. thanks again man.

Great video, extremely useful! Thanks!

Wow Brother, thanks for making life Easy

Very clearly explained - thank you!

Thank you, this was so helpful!

Thank you so much for this informative video. I have been looking for this for a long time. it solved my biggest problem.

great job with your channel, data is king

I’ve searched months and found this great video to solve my problem.

That is an amazing lesson, and you are Talent online teacher.

Appreciate the examples!

Very useful mate, your video helps me a lots

Really good, very clear tutorial

VERY USEFUL FOR BOTH BEGINNERS AND PROS

Thank you so much, exactly what I am looking for 😊👍👍👍

level 40 google sheets! Thank you.

pretty awesome helpful and useful to the highest levelz

Excellent. Well done

Excellent video, thank you!

Thank you its really helps me in query function.

Great tutorials!

This is great. Many thanks.

Thank you very much sir. Your video has helped me a lot.....

This video solved my biggest problem. Thanks and more power!

Great demo. Is there a way to retain the formatting from your Master sheet onto your new sheet so it looks like the Master Sheet?

Thanks.. it really help very much..

Thank you!!!! So easy to follow and understand :D

Helpful 👍

Wow, the IMPORTRANGE explanation at 9:58 is going to be a game changer!

Awesome TUT man

Ty for this video GOD BLESS U😊

Pure gold!!!

you explain it so well. thank you.

This is very fruitful and productive video that I have ever seen on RU-vid. I want to to do the same thing you did but Instead of just taking the same info from sheet 1 to the master list, I need to cut the information form sheet one to sheet two while I apply query. Why I need this and ask you that because I have an Google sheet and there is a column which is just for the status of the projects in which I have pending and completed. So, whenever it is going to be completed in the sheet 1, then I want it to automatically delete the completed project in sheet one and transfer it to the master list. I will appreciate that if you can help me in this regard, not only me need this but all most all of us need to have it. A huge thnx for you and your amazing and productive videos. Best RU-vid channel ever.

thank you , for great sharing

very helpful

Awesome!!

Great vid... thx. I can't find the limit of the number of tabs you can query with { }. I think I'll have to look at some scripts since my file will keep growing daily with new tabs that will need to be referenced. Thx again.

Wow, the subquery part is something I was looking for a long time. Since Google Sheet doesn't offer the "HAVING" SQL clause, this subquery is essentially the substitute for the "HAVING" clause.

Thanks so much for posting this video! any tips on using importrange where the source file has URLs in multiple columns that you would like to show & work in the destination file?

thanks You so much!!

Thanks for your help

Genius...

Hi, great tutorial. Can this query syntax be used from a script? Have you got some examples to indicate? Thanks

Thank you!

You sir, really gave me a lot of new knowledge, Also I would like to ask you a question related to database, In my case, I have multiple tabs in my spreadsheet, and I combine them into a big database using Query function, now that I have master database using query I'd like to add more column in master database that would also be added in my tabs or my mini databases, The problem is, the database using query function is dynamic, meaning that the data would grow as the data from others tabs increasing, so the column where I wrote in my master database is not valid anymore as the data is changing. Is there anyway how to put the data to follow the dynamic change by the query function? I'm really sorry for my bad english, thank you

Thanks a lot, great learning..so how I getting this files , its better to practice.

Great video. Thanks so much. Is there anyway to filter/sort each column of imported (importrange) data in the master?

Thanks for these videos - they are incredibly helpful. Is there a video to show how to combine data from 2 different sheets where the number of columns and the data is different but what would allow a join is that there is an email id for the records on both sheets. I want to create a sheet that would allow me to select columns from each of the sheets where there is a join for the email id. Is this possible?

Your video is really amazing. But I have a questions. I'd like to set up on Google Sheet where I can search just typing initials, such as "P" in a cell and them query makes the information in my sheet appear. Such as you've done with Shirt. Could you help with the funcion formula?

Great Presentations. Would you share the sheets data so we can practice?

Thanks for the awesome video. How can we overwrite importange spreadsheet data from destination sheet so source sheet data will be changed ?

These video are super helpful as the steps are explained very well. I have tried various formulas to meet what I need and while I can make each formula work on it's own, i'm having trouble finding the right combo. I have two workbooks. I need one workbook to vlookup / match a name in a column that is on another workbook. Example, John Doe appears in Coulmn H in 1 workbook named WRAP. I need the formula to search column B in another workbook Named Assets, to see if that name is true. If it is True, then it should highlight the name in WRAP workbook a color, using conditional formatting. Ideally, once John Doe has been removed from Assets workbook the Wrap workbook will remove the highlight. Sorry for the long comment. Is there another way to submit this. Would love your help!

Hi Thanks for the greate video If want to get data from H and G if text "IL" what is the function

Thanks for the information. Super helpful! Is it possible to utilize these, and have the data become static? I'd like to manually add data into my spreadsheet, but I don't want to to be overridden by the importrange data.

thanks you so much

Belled the Channel :-)

ThanQ alot 😘

I like the way you teach about google sheet and its functions, please help me to pulldata from one google sheet to other tik by tik

This is soon helpful! Any chance you can advise how to bring the formatting over from the other sheets as well? I have some subheads in rows that are supposed to be italic or bold, and they seem to not transfer over. Instead the master sheet uses the formatting that I apply to the master sheet specifically, which would work... except that formatting stays in place while the data gets moved around based on the other sheets. Thank you!

If pulling from another URL, should it still be A2:H or can it be A1:H? Thanks for the great videos.

What is the boundary limit you mentioned? Could I use 50-60 import ranges for example

Good evening, First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it. I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible? Thanks in advance!

Fantastic! Quick question, what If i want the query for more than one option. So in your example I want to show for IL and CA at the same time. How would you do that?

@ExcelGoogleSheets What if I have it more dynamic, referencing each of the importrange in 4 cells, one each. If one is blank (as it may be), is there a way to handle the error (similar to what iferror does)? My sheet still imports the same data (or behaves funny) when I delete one of the ranges... thanks for the help! Your videos are always very good and didactic!

perfect

I appreciate all the videos that your team share. I hope you could help me with this or point me in the right direction. I use Google Forms to get some information, The database is Google sheet document that google forms create, then I use IMPORTRANGE and VLOCKUP to use the data in a presentable Dashboard, but (this is the complicated part) I want to add information from the dashboard to the database and re-write the Cell where the "Comments" are. The cell after the new input will be: Comments 1 + Comments 2 + New added comments... HELP

Thant a lot

While pulling data from another spreadsheet with multiple tabs, can I specify the number of the tab instead of the name of the tab in the importance function? Basically, the source sheet from where I need to pull data from will have multiple tabs but I want to keep the first tab as the default source of the data, no matter what the name of the tab is. Data needs to be pulled from just one specific cell, say A1.

2021 useful from malaysia

Its a great Video and help alot in my reporting... i have too much data like 15000 line with Columns goes upto BS. getting error Result too large how to rectify this?

!!!! I used importrange function to copy a range from one sheet to another and I made some column in that sheet which were filled manually. how can i fix the manually/static filled data with the automatic/dynamic filled data?

I'm running into the same problem. "At 18:49-18:50 in the video, there is an error message that pops up saying "In ARRAY_LITERAL, an Array was missing values for one or more rows." Are you able to explain what that means, and how to fix it?"

Hi there, seems excellent and what I need but it doesn't work for me as my "IL" criteria is more diverse.. I need to look within the celle for one word (people answered paragraphs) can we please exchange on this issue? that would be very kind . Dave

Can we apply query in this way for 10 sheets, like you have done it for two sheets right likewise can we do it for 10 sheets in the same way

This is really good video. How can we combine 2 sets that the column are different. For example, the first sheet contains date, products and revenue. The second sheets contains date, products and expense?

if we add rows in both sheets and put query function where these updated data shown and how??

Thank you so much sir, thank you so much, sir. Your tutorials ones of the best because of being halpful and very clear explanation (English is not my native) ! My questions is: do you need to do subquery because there is no 'having' statement in the 'google sql' ?

Amazing. Thanks. Is there a short cut for chromebook to use the Dollar $ to lock the cell?