>> Hopefully this gets you going. I recommend double-checking my logic.
>>
>> ** **
>>
>> Asa
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Jorge
lf Of *Jorge Marques
> *Sent:* Tuesday, July 03, 2012 1:50 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ What do you recommend?? If Formulas,
> Tables with macros, vlookups?
>
> ** **
>
> Hi Asa thank you very much for your help, let me see if i c
(below the first range or above the last range)
>
> ** smaller than 1 "error", bigger than 100 should give "ask for budget",
> if you wish i can put here my if formulas that i used for one transporter.
> **
>
> Asa
>
> ** **
>
> *From:* excel-macros@g
mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Monday, July 02, 2012 2:34 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables
with macros, vlookups?
HI, the table in the example transporter AA the volumes are th
HI, the table in the example transporter AA the volumes are the columns
"1", "2 to 3", and "4 to 5", the column below is the weight, but there are
some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1,
i´m must charge 2 instead of one, because the rule weight overules the
other
Hi Jorge,
Looks like this can be handled using lookup formulas.
One good way to perform lookups is to have a number representing each of
your criteria each alone in their own cell, preferably all in the same table
for all transporters. You can use pivot tables to generate the cross
referenced
