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