#excel 13 - Use DGET function no need to use VLOOKUP function

Column Direction for Look Up Values in DGET vs VLOOKUP Functions in Excel. Generally, the VLOOKUP function looks up the value in the right direction but you can use the DGET function to look up the value in both directions.

What is DGET function in Excel?
=DGET (database, field, criteria)
DGET(database, field, criteria) The DGET function syntax has the following arguments: Database Required. The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.