G
grumblenoise
Hello folks,
Someone from accounts presented me with am interesting VLOOKUP problem
(interesting because I don't fully understand Excel).
I have a colum of figures from B6 to B38 I want to present the data in
D6 to D38 I would like to apply a % from another worksheet F6 to F8.
The % to be applied varies depending on the amount in B6 to B38
** EXAMPLE.
B6 to B38
12,191,984
12,497,627
10,854,088
10,628,373
9,950,800
9,667,445
10,129,664
10,308,847
10,629,769
10,413,796
10,358,897
10,367,604
10,673,805
10,274,035
9,977,234
10,277,299
9,910,732
10,104,963
10,318,960
9,952,196
10,079,331
10,197,333
10,355,460
10,362,925
9,802,999
10,005,238
9,986,293
9,166,972
9,513,328
9,927,705
10,279,043
10,059,406
11,169,842
% to be applied.
0 8,499,999 0.45%
8,500,000 9,999,999 0.35%
10,000,000 to 19,999,999 0.25%
20,000,000 to 39,999,999 0.15%
Make sense? I know what I want to do in my head but I don't know how
to make this VLOOKUP do it.
Can someone assisnt me?
Thank you
Someone from accounts presented me with am interesting VLOOKUP problem
(interesting because I don't fully understand Excel).
I have a colum of figures from B6 to B38 I want to present the data in
D6 to D38 I would like to apply a % from another worksheet F6 to F8.
The % to be applied varies depending on the amount in B6 to B38
** EXAMPLE.
B6 to B38
12,191,984
12,497,627
10,854,088
10,628,373
9,950,800
9,667,445
10,129,664
10,308,847
10,629,769
10,413,796
10,358,897
10,367,604
10,673,805
10,274,035
9,977,234
10,277,299
9,910,732
10,104,963
10,318,960
9,952,196
10,079,331
10,197,333
10,355,460
10,362,925
9,802,999
10,005,238
9,986,293
9,166,972
9,513,328
9,927,705
10,279,043
10,059,406
11,169,842
% to be applied.
0 8,499,999 0.45%
8,500,000 9,999,999 0.35%
10,000,000 to 19,999,999 0.25%
20,000,000 to 39,999,999 0.15%
Make sense? I know what I want to do in my head but I don't know how
to make this VLOOKUP do it.
Can someone assisnt me?
Thank you