Thank you so much.

Toppers wrote:
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)

Here is part of my data for Contract Discounts sheet 1
Contract Amount
[quoted text clipped - 24 lines]
Thanks.
Houa

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1