I assume you have tried vlookup and found that looking up the value fro
the first column is inadequate.
There is another lookup function which you can try, and that is th
DGET function.
DGET(database,field,criteria)
Database is the range of cells that makes up the list or database.
database is a list of related data in which rows of related informatio
are records, and columns of data are fields. The first row of the lis
contains labels for each column.
Field indicates which column is used in the function. Enter th
column label enclosed between double quotation marks, such as "Age" o
"Yield," or a number (without quotation marks) that represents th
position of the column within the list: 1 for the first column, 2 fo
the second column, and so on.
Criteria is the range of cells that contains the conditions that yo
specify. You can use any range for the criteria argument, as long as i
includes at least one column label and at least one cell below th
column label in which you specify a condition for the column.
So you define the database range to lookup, the field which you want t
lookup, and the criteria which you can specify (eg. header on top
lookup value below). you can customise the value you want to lookup
refer to help for more options
