Re: Vlookup with 2 different criteria before inserting a value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can simply add additional ranges.

Just make sure that all the ranges are exactly the same size:

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

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Tweetybird" <Tweetybird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9F9C8B6C-D7DD-4DCA-B4A9-2C06EC20751F@xxxxxxxxxxxxxxxx
Hi RagDyeR,

Is the criteria only limited to 2? I tried 3 and it didn't work.

Thanks,
Tweety

"RagDyeR" wrote:

You're welcome, and thank you for the feed-back.
--

Regards,

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

"Eqa" <Eqa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C70DC4BD-AC5B-412E-BDFC-13CF6BA307F1@xxxxxxxxxxxxxxxx
Great thanks for that RD.

Eqa

"RAGdyer" wrote:

<<<"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" <Eqa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D3F444E2-1AFA-48B3-A9D0-AD8621D2323B@xxxxxxxxxxxxxxxx
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








.

Relevant Pages

  • Re: Vlookup with 2 different criteria before inserting a value
    ... all ranges must be the same size. ... Please keep all correspondence within the NewsGroup, ... the corresponding row combination of country and product. ... of product it is a certain duty rate applies. ...
    (microsoft.public.excel.misc)
  • Re: Vlookup with 2 different criteria before inserting a value
    ... Please keep all correspondence within the Group, ... Criteria 1 Criteria 2 Criteria 3 Value return from col H ... where X contains the countries, Y the product type, and Z the duty ... the corresponding row combination of country and product. ...
    (microsoft.public.excel.misc)
  • RE: Country to IP range list
    ... > for specific servers and allowing only IP ranges by Country. ... > if there exists publicly available list of "Country to IP ranges". ... As its integrity cannot be secured on the Internet, the Atos Origin group ... Pueden estar protegidos por secreto profesional Si usted ...
    (Security-Basics)
  • Re: any way to confirm break-in?
    ... files are missing for basic daemons. ... Use a firewall rule to block access to the ... ssh port and only allow access from IP ranges you may expect you will ... can be physically located in another country, ...
    (comp.os.linux.security)