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