Hi,

I would like to know how to retrieve one value from a database list based on
multiple criteria. My list as the following headings:

Company, Year, Revenue ($)

I would like to perform some form of lookup function to retrieve a unique
value based on several criteria.

E.g. If Company = "company 1" and Year = "2000", return the value for
"Revenue ($)".

Bear in mind that there are several hundred company names, and that I would
like to be able to copy this formula into other cells, referencing different
criteria.

I've tried DGET, but can't work out how to use.

Any suggestions would be much appreciated.

RA