Prepare an Invoice.

[bablubg]

Good Morning! I have a small boutique shop. More than 100 types of dresses are being produced. I want to make my Invoice through ‘Excel’. I’ll entry all types of dresses at cell k5 to m5 (code#, description & price per piece). I made a sample cash memo which is attached. Please refer cell d21 where I write program. But so far I know I can’t write 100s of items in the program. Besides I want the invoiced amount in text. Anybody there who can help me.

[BadlySpelledBuoy]

Try this in D21:

=INDEX(L$1:L$200,MATCH(C21,K$1:K$200,0))

and this in H21:

=INDEX(M$1:M$200,MATCH(C21,K$2:K$200,0))

Then copy down.