Lookup with Multiple Criteria - VLOOKUP, MATCH solved with DGET - Google Sheets

Learn how to do lookups with multiple conditions using DGET function in Google Sheets. This will solve common issues with INDEX/MATCH or VLOOKUP with multiple criteria & lookup values.

#DGET #GOOGLESHEETS

[JosephErlewein]

Wow this helped me. I was looking to reference an existing address if "Lastname" existed in our member list.
=IFERROR(DGET('Memberlist'!$A$1:$L$400, "Address", {Lastname;D2}))

Then expanded this across some column headers and many rows. Wow, hundreds of address labels compiled in a minute.

THANK YOU!

[SudipChakraborty-dm]

You are a star - you don't know what a big help this video has 🙏🙏🙏

[aph]

Love your videos! Frequent and consistently good content from you 😄
Little nitpick about value ranges (categories): I use same number both as end of one range and start of the next one - this way I will not lose any values in-between, like 500 and a half, as 500 < 500.5 < 501.
I commonly see datetime ranges sliced with leftover values (say, reports for Monday 00:00 -23:59, Tuesday 00:00 - 23:59, etc - losing the last minute of the day).
Obviously this is only a problem if your values can at all fall in those cracks between your chosen ranges and you care about them.

[ranchanakiriyapong]

Great Video! I've tried with vlookup looking for multiple columns but not successful. I have learned something new. Thanks.

[juancarlosrojasvegal]

Ive been looking for this solution for a while. Thanks a lot

[andrewo]

THANK YOU, THANK YOU, THANK YOU. Much love from Malaysia.

[lpanebr]

Nice to know about the comparison operators! Thanks

[malikastar]

Very useful and interesting as usual, thank you

[Chanderv]

Thank You very much for great explanation 3:00

[paulocardoso]

Adicionando que em alguns países como o Brasil, na hora de criar as Matrizes com os colchetes, o comando só funciona usando barra invertida ("\") no lugar da vírgula ... In some countries you have to use "\" instead of commas for the Curly Brackets formula

[donembutido]

Awesome! worked beautifully, great explanation. much better than concatenating strings before doing vlookup

[vehuggans]

Great video. How do you get the array bracket nested in the formula

[cwlindWX]

This is also perfect for finding dates between date ranges.

[nieldo]

Great video, it helped me out. Thanks.

[GV-gnmj]

Thanks for posting. Why in the minute 9.40 we had to use & to reference a cell and in the previous exercise we did not, we just name b2, d2 in the dget function?

[alitir]

Yet another amazing video thank you! I really appreciate it if you could write me the formula to use the same DGET with an Array so it could fill down I've looked everywhere & cant find DGET with an Array formula - I have multiple conditions like above

[aarondianna]

Hello, how would I look up the value with a close match and not an exact match

[ryandart]

Is there a way to build in a does not equal aspect to the array? Or a way to filter out more to prevent the duplicate error?

[paulsalcedo]

Can I use this to return a duplicate value (target column: A:A) and output that return value (C:C) based on one cell (B:B)? By the way, how can I reach you out to discuss this in-depth?

[SunilKumar-lnvr]

can we use arrayformula with the Dget function?