Sorry, I couldn't find out the cause of the problem from the picture. Perhaps
if you attach the invoice and product files themselves!

Stefi


€ž1image€� ezt Ã*rta:


I ended up using a more simplified version that someone else shared with
me,
it goes like this

QTY DISCOUNT vlookup works like this =VLOOKUP(D19,DTABLE,2).
0 0%
5 2%
10 5%
20 8%
50 10%

!your help and support was much appreciated!.

I have another question that i hoped you might help me with i have
attached a screen shot of the invoice to help explain what i mean, i
have copied a formula down the description list and no matter what i do
i can't get the 3rd item to display the correct description


+-------------------------------------------------------------------+
|Filename: invoice problem.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3926 |
+-------------------------------------------------------------------+

--
1image
------------------------------------------------------------------------
1image's Profile: http://www.excelforum.com/member.php...o&userid=28203
View this thread: http://www.excelforum.com/showthread...hreadid=477455