Retrieving data from a database list

G

Guest

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
 
A

Arvi Laanemets

Hi

=SUMPRODUCT(--(Company="company 1"),--(Year=2001),Revenue)
Where Company, Year and Revenue are references to data ranges in according
columns (NB! All ranges must be of same dimension).

Arvi Laanemets
 
G

Guest

Thanks Arvi, that works really great. (I would never have thought to use
SumProduct - bizzare!)

RA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary data 2
Seeding in Drop Down List 3
Lookup to create a table of data in terms of selection 1
Retrieve data from Access database and fill data in form 0
certain rows from a lot of data 1
retrieving data from variable workbooks 3
dget or dsum criteria 1
Retrieving value from list based on dynamic condition 3

Top