81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns a number corresponding to the error value in a different cell.

How To Use in Sheets


External Links

DGET - Powerful VLOOKUP, INDEX-MATCH Replacement - Google Sheets Tutorial

Learn how to match data, join data from different tables & worksheets using DGET function in Google Sheets. Learn differences between DGET, VLOOKUP, INDEX/MATCH and why DGET might be an interesting or sometimes better alternative to VLOOKUP & INDEX/MATCH.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.