MakeUseOf Follow I’ve been overcomplicating Excel lookups with VLOOKUP — this obscure function changed that If your VLOOKUP formula needs a helper column, try DGET instead. https://www.makeuseof.com/the-dget-function-for-excel-lookups/ makeuseof.com
