VLOOKUP
Try:
Lookup table on Sheet2 (A1:B5)
£0.00 0.00%
£10,001.00 1.00%
£20,001.00 2.00%
£40,001.00 3.00%
£80,001.00 5.00%
In your discount cell:
=VLOOKUP(A4,Sheet2!$A$1:$B$5,2,TRUE)
"HOUA-CARLOS" wrote:
Here is part of my data for Contract Discounts sheet 1
Contract Amount
$15,000
$4,000
$60,500
$73,235
$8,025
$68,135
$12,000
$45,000
$82,002
$35,258
Here is the date for Lookup Table
If the contracts is under $10,000 there are no discount. Between $10,000 and
$20,000 there is a 1% discount, for $20,000-$40,000 there is a 2% dicounts,
between $ 40,000 and $80,000 there is a 3% discount and contract over $80,
000 there is a 5% discount.
Hopefull this will help you.
Toppers wrote:
Can you post your lookup table please.
Hi.
I'm trying to enter the VLOOKUP function for a discount on contract amount.
[quoted text clipped - 9 lines]
Thanks.
Houa
|