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