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.
and here's a tip: to select only one column, enter this range: A: A or whatever column you want, with its name on both sides of the ":" symbol. The left side of the column is the start point and left side is end point, so you could do something like A12:A too.
I don't have enough words to appreciate you putting out all this amazingly explained information for free on UA-cam... Thank you...!!!! Thank you....!!!!! Thank you....!!!
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
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.
This is very fruitful and productive video that I have ever seen on UA-cam. 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 UA-cam channel ever.
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?
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 so much for these videos! What I have yet to find is a video that addresses querying the same tab/sheet from hundreds of different worksheets. So, my situation is such that I have a running list of reports for a calendar year. By the end of the year, there are 400 or so reports. Within the reports, there is a equipment2 sheet that I am trying to query with a range from B4:E28, where the results can be either 1 row, or all 25, depending on how much equipment was used for that given incident (potentially no rows, if no equipment was used). I have a script that imports all the URLs from the reports into a tab/sheet that is called ReportURLs. Column D houses the URLs. So, how can I query ReportURLs!D2:D dynamically to pull out all the data? Thanks!
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!
No, according to my knowledge. because query function needs its next lines to be empty. when you'll write the second query function, first one will give you an error: "Array result was not expanded because it would overwrite data in A249". A249 just for the example.
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?
@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!
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?"
!!!! 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?
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.
@@ExcelGoogleSheets I was also wondering because it wasn’t picking up the right match. It was refereeing to the row number instead of match. I guess it was because I used rang names when referencing to range and gave name to the whole colum not some rows as I wanted to make the names range dynamic. But somehow it is picking up right not sure what happened but problem solved. I did =index(importrange),match(importrange)
Thank you for nice series on Google query and other advanced techniques. I have a problem regarding Google Finance. Hope you can give me proper guidance. The problem is that I wish to compute Weekly, Bi-weekly and Monthly gains by a list of stocks. Google finance gives 'changepct' for daily data. But for weekly data it doesn't. I have made a formula using query to compute weekly percent change. But for Bi-weekly I have not yet succeeded. Can you suggest any formula for bi-weekly and monthly gains of stock prices. May be I am missing some where some thing.....
@@ExcelGoogleSheets Thanks for your quick response. As you asked, let me explain. There is a provision in GoogleFinance to list the weekly prices of a stock. With that I made a formula using queries, which gives the desired result. The process is a bit cumbersome. Here how i did it. Using query from GoogleFinance weekly price list - sorted in desc order, i) I extracted the first price (using Limit 1)-say A, II) extracted sum of first two prices (using Limit 2)-say A+B. Knowing price A and sum A+B, it is just use of algebra to get A-B [2A-(A+B)]. This will give latest weekly price change. Then computing % change is easy. This resulted in a large formula. And let me inform you that I have also computed the bi-weekly and monthly percent changes. But these all are large formulae and prone to make mind boggling mistakes while constructing it. Hence I wanted to know how to select the price using the GoogFinance output where the first column is date. I have seen your video on extraction of data based on date limits. But that is not working with in line Google Finance data, neither as a date or number. This would have made the life easier. Can you suggest something on this problem? The answer is a bit long, but then I have to explain any way.
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 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
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?
because if we enter data in linked sheets than master sheet shown the data in between sheet and sequence will be disturb. i want all updated data should be shown at the last.. is there any option please let me know.
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' ?
Could you please say what word to use when I need to query information not from a column (Col1/Col2/...), but from a line (which are designated as '1', '2', '3'). I have a page with columns often changing their positions, so I need to query a value from (line2) if (line1) contains 'specific-word'
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.
This is very helpful, but I another question. I have used the Query ImportRange function to move data from one sheet to another but my SELECT WHERE is referring to a specific date. I.e. I want to move all data where the date is 5/1/2020 and later. When I use the formula you suggested it works but all of my information is showing up on one cell block. How do I fix this?
hi, my sheet have merge 10 cells, when using query function it only read the first line correctly than the second line staright away jump to data which is line 21. how can i solve this issue.
Given a column of spreadsheet URLs and possibly next to each a range I. E. Transactions!A2:b30, is it possible to automatically pull and join the data from all those sheets?
I had to use google script so that when a new URL and range is added, it builds the formula to join all the importrange formulas inside a query formula based on the URL list
So Very Helpful and Succinct! I would appreciate knowing if there is a way to use an item on a Dropdown List (MASTER BEDROOM), as the QUERY? As in.... =QUERY(SELECTIONS!$A$1:$N$201,"SELECT A, B, C, D, E, F WHERE D = 'MASTER BEDROOM'",1) but replace 'MASTER BEDROOM' with the cell reference $A$3 that is a Dropdown List Also is there a way to "SELECT all columns, so complete rows of data are returned if they contain MASTER BEDROOM in column D? Cheers!
Hi, I have a question, I apply this formula =QUERY('Master Data'!$A$1:$T,"Select E,F,T Where T = 'City Name",1) as you can see from the formula how i can add more city but its in the same master data sheet?
This was so helpful. But when i'm using query(importrange) function to get data from one sheet to another sheet data is not fetching all the time. some times it is given error like #value. May i know solution here with google script or something. Thank you so much in advance!🙂
This entire series is amazingly helpful. It is THE definitive guide to using Sheets like a pro. Thank you!
Agree! I wish this was in my search results 2 years ago
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.
and here's a tip: to select only one column, enter this range:
A: A
or whatever column you want, with its name on both sides of the ":" symbol. The left side of the column is the start point and left side is end point, so you could do something like A12:A too.
I don't have enough words to appreciate you putting out all this amazingly explained information for free on UA-cam...
Thank you...!!!! Thank you....!!!!! Thank you....!!!
I’ve searched months and found this great video to solve my problem.
Sir, you are the Best, your videos have contributed too much in me gaining respect in my office
I'm learning new tricks...This tricks also helpful for learning SQL queries..Thank you brad, very concise and clear..
Your videos are the best. I have been able to build an entire database in multiple sheets because of your awesome tutorials. THANK YOU!
pretty awesome helpful and useful to the highest levelz
Thank you so much for this informative video. I have been looking for this for a long time. it solved my biggest problem.
Awesome my main man. Had a bit of panic at first not working but I had forgot the QUERY at the beginning. All great.
This is amazing and your talent of explaining the steps inspires me!
great job with your channel, data is king
Thank you so much! I have been able via your videos to minimize manual updates. Thanks again.
This is what I have been looking for. Thank you very much. Easy to understand and follow.
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
Thank you very much sir. Your video has helped me a lot.....
Greetings from Brazil. I would like to thank you for this serie, it was very helpful
Esse é o melhor professor do UA-cam!!!
This video solved my biggest problem. Thanks and more power!
:)
@@ExcelGoogleSheets what if you need to filter more than 1 state, instead of just IL, how do you do that?
Covered in part one of these series.
Thank you SO much - been having so much trouble sorting text data and this finally solved my problem at work!!
That is an amazing lesson, and you are Talent online teacher.
Helpful 👍
Excellent. Well done
This is great. Many thanks.
This was so helpful. Literally the only place I found such a clear answer. Great video
Thanks for the tutorial on using QUERY with IMPORTRANGE. Really helped me!
Thank you its really helps me in query function.
Excellent video, thank you!
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.
Correct 👍
@@ExcelGoogleSheets this is so useful that I have enhanced my spreadsheets in multiple places today. Thank a lot brother!
thank you , for great sharing
Awesome tutorial! Loved it. Thanks for putting in such efforts to educate folks.
Glad you liked it!
Ty for this video GOD BLESS U😊
you explain it so well. thank you.
This is very fruitful and productive video that I have ever seen on UA-cam. 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 UA-cam channel ever.
Could you please answer my question?
VERY USEFUL FOR BOTH BEGINNERS AND PROS
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?
You are a great teacher. These videos are super helpful.
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.
You are a WONDERFUL teacher, Thank You!😊
Wow, the IMPORTRANGE explanation at 9:58 is going to be a game changer!
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?
Thank you so much, exactly what I am looking for 😊👍👍👍
Thank you for your sharing. I learn a lot from this video.
You all are awesome. Thank you for the great videos you create and share!
hi..can u pls help me coz, after i the formula when i enter doesnt extract my data only showwd is the headers..thanku
Wow amazed.. thanks again man.
Thanks for your help
Amazing. Thanks. Is there a short cut for chromebook to use the Dollar $ to lock the cell?
No F4 on Chromebook?
@@ExcelGoogleSheets unfortunately, nope. Even if I try to use an external keyboard, it does not work with the same functionality
Great video, extremely useful! Thanks!
Thanks so much for these videos! What I have yet to find is a video that addresses querying the same tab/sheet from hundreds of different worksheets. So, my situation is such that I have a running list of reports for a calendar year. By the end of the year, there are 400 or so reports. Within the reports, there is a equipment2 sheet that I am trying to query with a range from B4:E28, where the results can be either 1 row, or all 25, depending on how much equipment was used for that given incident (potentially no rows, if no equipment was used). I have a script that imports all the URLs from the reports into a tab/sheet that is called ReportURLs. Column D houses the URLs. So, how can I query ReportURLs!D2:D dynamically to pull out all the data? Thanks!
Thank you!!!! So easy to follow and understand :D
Glad it was helpful!
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
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!
Wow Brother, thanks for making life Easy
Really good, very clear tutorial
Very useful mate, your video helps me a lots
can i have a query function on the upper part of the sheet and a different query function on the lower part of the same sheet?
No, according to my knowledge.
because query function needs its next lines to be empty.
when you'll write the second query function, first one will give you an error: "Array result was not expanded because it would overwrite data in A249".
A249 just for the example.
You can, so long as the first function has enough space for expected results.
Very clearly explained - thank you!
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?
Hi Great videos, the explanation is clear, but can I do the editiing on the data that I have imported to new spreadsheet?
No.
@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!
Appreciate the examples!
Thank you, this was so helpful!
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?"
Pure gold!!!
!!!!
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 have the same probleme bro
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.
Thanks.. it really help very much..
7:50
What if the 2 tables (transactions and transactions previous) have different columns/different number of columns?
How would the Col8 thing work?
Watch my Pivot Table from multiple sheets video for a solution.
Is it possible to filter both IL & CA at the same time during query and importrange?
level 40 google sheets! Thank you.
Does it in effect do a join on a common field in, both sheets?
No. Google Sheets QUERY doesn't support SQL like join. Use VLOOKUP to get something similar to join.
WHAT IS YR GOODNAME SIR I AM SEARCHING FROM LONGTIME I WANT YR WEBSITE ALSO
Hi there. Using this formula,Is it possible to do multiple filter in the same column?
Thanks, with the query how do we add the TAB "name" to each row so we know which TAB the match came from
Any video to use query function with index match, or any alternative for this
I don't understand why you would need that.
@@ExcelGoogleSheets I was also wondering because it wasn’t picking up the right match. It was refereeing to the row number instead of match.
I guess it was because I used rang names when referencing to range and gave name to the whole colum not some rows as I wanted to make the names range dynamic.
But somehow it is picking up right not sure what happened but problem solved.
I did =index(importrange),match(importrange)
Great tutorials!
Thank you for nice series on Google query and other advanced techniques.
I have a problem regarding Google Finance. Hope you can give me proper guidance. The problem is that I wish to compute Weekly, Bi-weekly and Monthly gains by a list of stocks. Google finance gives 'changepct' for daily data. But for weekly data it doesn't. I have made a formula using query to compute weekly percent change. But for Bi-weekly I have not yet succeeded. Can you suggest any formula for bi-weekly and monthly gains of stock prices. May be I am missing some where some thing.....
How did you do the formula for weekly percent change?
@@ExcelGoogleSheets Thanks for your quick response. As you asked, let me explain.
There is a provision in GoogleFinance to list the weekly prices of a stock. With that I made a formula using queries, which gives the desired result. The process is a bit cumbersome.
Here how i did it. Using query from GoogleFinance weekly price list - sorted in desc order, i) I extracted the first price (using Limit 1)-say A, II) extracted sum of first two prices (using Limit 2)-say A+B. Knowing price A and sum A+B, it is just use of algebra to get A-B [2A-(A+B)]. This will give latest weekly price change. Then computing % change is easy.
This resulted in a large formula. And let me inform you that I have also computed the bi-weekly and monthly percent changes. But these all are large formulae and prone to make mind boggling mistakes while constructing it. Hence I wanted to know how to select the price using the GoogFinance output where the first column is date. I have seen your video on extraction of data based on date limits. But that is not working with in line Google Finance data, neither as a date or number. This would have made the life easier. Can you suggest something on this problem?
The answer is a bit long, but then I have to explain any way.
Yea, I'm afraid my solution wouldn't be simple either.
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 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
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?
because if we enter data in linked sheets than master sheet shown the data in between sheet and sequence will be disturb. i want all updated data should be shown at the last.. is there any option please let me know.
Thanks a lot, great learning..so how I getting this files , its better to practice.
Awesome TUT man
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' ?
yes.
with the importrange query.. i want to use formula " select B,C,D WHERE B= " CELL REFERENCE FROM CURRENT SHEET "... HOW DO I DO THAT ?
What is the boundary limit you mentioned? Could I use 50-60 import ranges for example
Awesome!!
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?
ThanQ alot 😘
How do I IMPORTRANGE (with formatation) in a way that when I edit the Sheet I've imported it will refresh automatically at the new Sheet? Thank you!
Could you please say what word to use when I need to query information not from a column (Col1/Col2/...), but from a line (which are designated as '1', '2', '3'). I have a page with columns often changing their positions, so I need to query a value from (line2) if (line1) contains 'specific-word'
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.
This is very helpful, but I another question. I have used the Query ImportRange function to move data from one sheet to another but my SELECT WHERE is referring to a specific date. I.e. I want to move all data where the date is 5/1/2020 and later. When I use the formula you suggested it works but all of my information is showing up on one cell block. How do I fix this?
hi, my sheet have merge 10 cells, when using query function it only read the first line correctly than the second line staright away jump to data which is line 21. how can i solve this issue.
Given a column of spreadsheet URLs and possibly next to each a range I. E. Transactions!A2:b30, is it possible to automatically pull and join the data from all those sheets?
I had to use google script so that when a new URL and range is added, it builds the formula to join all the importrange formulas inside a query formula based on the URL list
if we add rows in both sheets and put query function where these updated data shown and how??
So Very Helpful and Succinct!
I would appreciate knowing if there is a way to use an item on a Dropdown List (MASTER BEDROOM), as the QUERY?
As in.... =QUERY(SELECTIONS!$A$1:$N$201,"SELECT A, B, C, D, E, F WHERE D = 'MASTER BEDROOM'",1) but replace 'MASTER BEDROOM' with the cell reference $A$3 that is a Dropdown List
Also is there a way to "SELECT all columns, so complete rows of data are returned if they contain MASTER BEDROOM in column D?
Cheers!
ua-cam.com/video/nLW8SerwnJo/v-deo.html
Hi, great tutorial. Can this query syntax be used from a script? Have you got some examples to indicate? Thanks
Thanks for the awesome video. How can we overwrite importange spreadsheet data from destination sheet so source sheet data will be changed ?
Hi, I have a question, I apply this formula =QUERY('Master Data'!$A$1:$T,"Select E,F,T Where T = 'City Name",1) as you can see from the formula how i can add more city but its in the same master data sheet?
This was so helpful. But when i'm using query(importrange) function to get data from one sheet to another sheet data is not fetching all the time. some times it is given error like #value. May i know solution here with google script or something. Thank you so much in advance!🙂