VLOOKUP with Multiple Criteria (no helper columns) for Google Sheets

This formula only works in Google Sheets, not Excel.

[speechaboutlanguage]

I just wanted to say, this is a GREAT video, thank you!!! I added an "iferror" statement to my query so that if there were any blanks, the #NA error would return blank. Here is what my actual formula looked like: =iferror(query($P$13:$AM$10010, "select AA where Y = """&$B$14&""" and Z = """&D$13&""" ", 0), "")

[gregorygiageos]

Thank you times a million! After spending a couple of hours trying other methods, this was perfect and helped so much, I'm so thankful.

[mohamadnaufalhafizh]

Cool trick!, this solved complex logic using index and match, thank you so much!

[RodrigoCorreia]

Excelent!!! I was looking for this for HOURS!!!! Thank you very

[aakemp]

That was awesome. Solved my problem like a charm. Thank you sooo much!!!

[thepaintingplant]

Is it possible to use this formula if the cell I want to match is in the same column as the cell I'm putting the information in? I want a way to enter information above the table and have a row displaying the data for whatever part of the table I choose, kind of like a search field. That would mean changing part of the formula to "select E where B = """&B2&""" and C = """&C2&""" ". But I can't seem to get this to work, and I don't know what I'm doing wrong.

[mariamelendez]

Is there a way to concatenate results from the query if there's more than one unique result? For example, if there had been two or three different prices for "San Francisco" & "North" and you want the 3 prices to be the result in the same cell

[lukasp]

Does this work with array formulas, I know and functions don't work with them and I'm trying to find a work around that solves this problem

[bapibp]

How can i this formula dynamically use with arrayformula or any other.thank you.

[kellypurdue]

Worked great except did not give results if there were two rows with the same name but different 2nd criteria. Idea as to why?

[ankurbhatia]

Doesn't seem to work with dates. Any suggestions?

[krishnakanth]

Thanks for the video, It made my work easy....!!

[AshKetchumnakamoto]

How to substract 2 list who has Query formule ?

[Hemzees]

I tired this but it just tells me formula parse error. I have been at it for hours but can't seem to find any error in my syntax