What a load of rubbish. The function is a) quite old b) not particularly useful and c) most certainly no replacement for VLOOKUP. That would be XLOOKUP. DGET lways need a header immediately above the resulting value so can't use it to look up all the values in several rows. If you want real interactivity, use FILTER.
Very Helpfull and super easy to understand.
DGET is similar but also different, this depends on your use case. I agree with the other comments , the replacement for VLookup is XLOOKUP.
New kid is xlookup for several years now
Dear please tell me if i want to apply it on many rows. May i drag this function.
❤❤❤
Vlookup + Match
What about XLOOKUP()??
What a load of rubbish. The function is a) quite old b) not particularly useful and c) most certainly no replacement for VLOOKUP. That would be XLOOKUP. DGET lways need a header immediately above the resulting value so can't use it to look up all the values in several rows. If you want real interactivity, use FILTER.