Using the DGET Function in Excel

http://www.computergaga.com/blog/lookup-your-data-with-the-dget-function/ Use the DGET function in Excel to lookup and return data in a large table. The DGET function is more powerful than alternatives such as Vlookup as it can look to its left and lookup using multiple conditions. Take your lookups to another level with DGET.