Google Sheets QUERY Function, VLOOKUP with Multiple Matches Tutorial - Part 6

[@kdzmuzo]

PERFECT. WAS EXACTLY THE SOLUTION I NEEDED! PARDON THE ALL CAPS, ITS THE COFFEE

[@takaakiyamada7294]

Unlike VLOOKUP Function, QUERY Function returns multiple values! So nice! Thank you. :-)

[@lazalazarevic6192]

Great video, thanx again.... Have you noticed that your chanel has 2 playlists for QUERY function?

[@rijeeshr]

at the end its showing 3 out put values for 6332-26-857 stock . is this possible as output values as drop down list

[@jimkwon4905]

Thanks as this formula works if you manually enter the number into cell B21. HOWEVER, if cell B21 is determined from a formula or even equals a cell value in the same worksheet this doesn't work. Do you know if there is a work around this?

[@eloureirotubeyou]

Just to thank you for all these amazing videos! :)

[@jimkwon4905]

Thank you for this video! This works as long as I entered a hyphenated number like the one you did in your video, however if I change the format from the hyphenated number to a number (ie 4) or a percent (3.20%) it doesn't work

[@michellechristinelo5136]

Hi, how can I combine this formula with an importrange formula?

[@Excellent625]

Hi, Thank you very much. What about if I want to use this method (Query as a vlookup) for the all column and not only 1 row?

[@joaobarbosa8889]

Thank you. This will open up so many possibilities to me... But I had a problem. My goal was for the function to look up a list of terms in a column. Those terms will show up more than once and there is a corresponding value for each of those instances in another column. I don't want it to spit out those numbers in a list: I want it to add them all together and then give me that number aggregated. So I enveloped the whole formula in a simple Sum function and it works. BUT there is a term that is listed that doesn't have any match in the look-up table. Yet, it spits out the value 1. Why?

[@usmanlatif4985]

Nice! Thanks... How can I use a date , specified in a cell, and add all numbers where in rows where the date matches exist?

[@ashishlohani7914]

nice video

[@deepouterspace]

Super! Thanks, very helpful

[@aliviazhang3267]

If I use your case, I am wondering how I can count the number of different stock number for each type of shoe. Like for example, I would like an output for Running Shoes to have 5, Training Shoes to have 6, etc. And what if I want to have the results in a different sheet? Is the thing. I want possible?

[@ExcelGoogleSheets]

Yes you can kzbin.info/www/bejne/imqbg6qio8mGkM0

[@aliviazhang3267]

@@ExcelGoogleSheets Thank you! However, I am working with emails (Trying to find the number of different children under the same email), so I feel a pivot table will not be too efficient. Is there another way? If not I can just go with that. Thanks for your help!

[@ExcelGoogleSheets]

I don't know what your data looks like, but the fact you have emails doesn't change anything.

[@christopherroxas23]

Is it possible to just get the value before the last match? without knowing how many numbers of matches. Thank you.

[@karanmadan6403]

thanks a lot buddy.. did my job pretty well.. you got one more subscriber.. :P

[@cherrymeimeia666]

If different sheet how should I use query? Thanks

[@garbhanmckenna8201]

Hi, great video. I was wondering can this query formula be tweaked to return the row number of each match rather than text value. ? Really appreciate the video.

[@shanstatedrd7295]

Thank you very much.

[@johnn4314]

Can you use the query with importrange function?? Im trying to reach across documents and grab every single instance of a certain title. Just like you did with the Query but across sheets

[@ExcelGoogleSheets]

Yes, but then you'll need to refer to your columns as Col1, Col2, Col3 instead of A, B, C

[@johnn4314]

By the way I literally just got a raise because of some stuff I learned from you. so thank you kindly sir

[@ExcelGoogleSheets]

That's the best comment I've ever had on a video.

[@johnn4314]

Well the guy thinks i'm smart now so i'm staying up all night trying to learn but yea watching your apt script tutorials right now. thank you man. i seriously needed a good job and now because of those regex formulas !

[@aayushgautam5778]

hey bro i ave a problem in headers if i am typing 0 in headers so the result is NA but if i am selecting number 4 then the result is first 4 products name.. i mean to say all top 4 products name are there as a result This happen in query functon

[@ExcelGoogleSheets]

If you don't want headers to show up, don't select headers in your data range and use 0.

[@aayushgautam5778]

@@ExcelGoogleSheets thanks for replying

[@jhone3241]

"QUERY COMPLETED WITH AN EMPTY OUTPUT" I'm getting this error.... what might be the reason?

[@ahmolinarojas]

Great Tutorial! I am interested in the Query returning multiple results How can you lookup for other values which have multiple results? I mean, how to put a column or array at the condition 'where C='?

[@ExcelGoogleSheets]

Everything about QUERY function is here kzbin.info/www/bejne/mIiZgWWPq7GskMk I assume you want SQL IN like statement, there is a video in the playlist covering that too.

[@TruthofDilly]

@@ExcelGoogleSheets what if you have a million lines? You can’t use the query then can you?

[@Tom-sg4nh]

How would you return the results into one cell?

[@joaobarbosa8889]

If it's a simple number, I did it by envoloping it all in a simple Sum function.

[@crell3]

Thanks!

[@cuneiformscript2665]

🙏🏻

[@GiadinhBom]

This formula is wrong =QUERY(IMPORTRANGE("1TygEZVj-AQO_eXHRQtSpNHYD2qGdAqRYSAc-CjvhNMY","Sheet2!E4:K47"),"select G where H='" & B2 & "' limit 2",0) you must change "Select Col3 where Col4 ='" & B2 & "' limit 2",0)