vlookup with more than 1 condition

P

PEDRO

Hello All
I have this situation:
column a can be any country
column b any industrial sector
column c a brand name

I want the cell to return the value in column d that meets the criteria that I specified for columns a to c.
The problems is that the criteria is in a different file to the file where the data sits.
I have tried an array formula but did not work.
can anybody suggest a solution?

Thanks all
 
J

JS

Try the DGET function.

-----Original Message-----
Hello All
I have this situation:
column a can be any country
column b any industrial sector
column c a brand name

I want the cell to return the value in column d that
Click to expand...
meets the criteria that I specified for columns a to c.
The problems is that the criteria is in a different file
Click to expand...
to the file where the data sits.
 
F

Frank Kabel

Hi Pedro

though on the site http://www.mvps.org/dmcritchie/excel/vlookup.htm
a double lookup (with two conditions) is described I would use DGET for
you problem

=GET('[Data.xls]Sheet1'!$A$1:$D$999;4;A1:D2)
where the data is stored in the workbook "Data.xls" (Range A1:D999) and
your search criteria in A1:D2 on the active workbook.

Note: AFAIK this works only then the Data workbook is open.

HTH
Frank
 
T

theillknight

I can't quite figure out how to use this function (dget())

Can you give an actual example
 
Top