I have multiple columns of data. I want Col T to insert a duty rate from a
refernce list depending on the country of supply in Col C and the type of
product in Col I. What formula do I need to enter so that it cross references
these 2 variables.

Thanks in anticipation.

Eqa

try this,
=sumproduct(--(logical 1),--(logical 2), col of duty rate)

"Eqa" wrote:

I have multiple columns of data. I want Col T to insert a duty rate from a
refernce list depending on the country of supply in Col C and the type of
product in Col I. What formula do I need to enter so that it cross references
these 2 variables.

Thanks in anticipation.

Eqa

Eric,

What do I place in logical 1 and logical 2? the cell C1 and I1 or a list of
all the countries and a list of all the product types? And how does it then
distinguish which country and which product gets which duty rate?

Eqa

"EricBB" wrote:

try this,
=sumproduct(--(logical 1),--(logical 2), col of duty rate)

"Eqa" wrote:

I have multiple columns of data. I want Col T to insert a duty rate from a
refernce list depending on the country of supply in Col C and the type of
product in Col I. What formula do I need to enter so that it cross references
these 2 variables.

Thanks in anticipation.

Eqa

say your duty rate is in col D,
=sumproduct(--(c1:c10="what country?"),--(i1:i10="product type"),--(d1:d10))
change the range to suit your needs.

"Eqa" wrote:

Eric,

What do I place in logical 1 and logical 2? the cell C1 and I1 or a list of
all the countries and a list of all the product types? And how does it then
distinguish which country and which product gets which duty rate?

Eqa

"EricBB" wrote:

try this,
=sumproduct(--(logical 1),--(logical 2), col of duty rate)

"Eqa" wrote:

I have multiple columns of data. I want Col T to insert a duty rate from a
refernce list depending on the country of supply in Col C and the type of
product in Col I. What formula do I need to enter so that it cross references
these 2 variables.

Thanks in anticipation.

Eqa

Eric,

I don't think I explained myself clearly.

I'll start again:
Col A has a drop down box with all the countries we import fom,
Col B has a drop down box with all the types of product we import
In Col C which is the duty payable dependent on which country and what type
of product it is a certain duty rate applies.

What do I need to do so that this will understand different rates for the
same product from different countries.Forget that I have a look up list
because aI think this is cinfusing me. So tell me step by step what I need to
establish so that this works.

Hope this is clear and thanks,

Eqa

"EricBB" wrote:

say your duty rate is in col D,
=sumproduct(--(c1:c10="what country?"),--(i1:i10="product type"),--(d1:d10))
change the range to suit your needs.

"Eqa" wrote:

Eric,

What do I place in logical 1 and logical 2? the cell C1 and I1 or a list of
all the countries and a list of all the product types? And how does it then
distinguish which country and which product gets which duty rate?

Eqa

"EricBB" wrote:

try this,
=sumproduct(--(logical 1),--(logical 2), col of duty rate)

"Eqa" wrote:

I have multiple columns of data. I want Col T to insert a duty rate from a
refernce list depending on the country of supply in Col C and the type of
product in Col I. What formula do I need to enter so that it cross references
these 2 variables.

Thanks in anticipation.

Eqa

<<<"Forget that I have a look up list because aI think this is cinfusing
me."

You *cannot* forget about this lookup list, because that is the *basis* for
your required information..

Ideally, you could have a datalist of 3 columns, in an out-of-the-way
location, say X, Y, and Z,
where X contains the countries, Y the product type, and Z the duty rate for
the corresponding row combination of country and product.

Say your datalist went from X2 to Z50.
Say your dropdowns started in A2 and B2.

Enter this in C2:

=SUMPRODUCT(($X$2:$X$50=A2)*($Y$2:$Y$50=B2)*$Z$2:$ Z$50)

And copy down as needed.
--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------

"Eqa" wrote in message
...
Eric,

I don't think I explained myself clearly.

I'll start again:
Col A has a drop down box with all the countries we import fom,
Col B has a drop down box with all the types of product we import
In Col C which is the duty payable dependent on which country and what
type
of product it is a certain duty rate applies.

What do I need to do so that this will understand different rates for the
same product from different countries.Forget that I have a look up list
because aI think this is cinfusing me. So tell me step by step what I need
to
establish so that this works.

Hope this is clear and thanks,

Eqa

"EricBB" wrote:

say your duty rate is in col D,
=sumproduct(--(c1:c10="what country?"),--(i1:i10="product
type"),--(d1:d10))
change the range to suit your needs.

"Eqa" wrote:

Eric,

What do I place in logical 1 and logical 2? the cell C1 and I1 or a
list of
all the countries and a list of all the product types? And how does it
then
distinguish which country and which product gets which duty rate?

Eqa

"EricBB" wrote:

try this,
=sumproduct(--(logical 1),--(logical 2), col of duty rate)

"Eqa" wrote:

I have multiple columns of data. I want Col T to insert a duty rate
from a
refernce list depending on the country of supply in Col C and the
type of
product in Col I. What formula do I need to enter so that it cross
references
these 2 variables.

Thanks in anticipation.

Eqa