I will be grateful if I can receive help regarding this problem:
I am trying to build an invoice workbook for my clinic. I have 2
problems:
1. I have almost 25 different procedures and 4 different room
categories. The professional charges for the procedures vary according
to the room category e.g for procedure x, the charge will be 5 for
general room, 8 for semispl room, 13 for spl room etc. with no fixed
ratio of increase.In the invoice form, as soon as i select the room
type and procedure, I need to get the price automatically. I have made
a table assigning the prices. I have tried the vlookup, offset but to
no avail. The table is on a different worksheet to avoid the clutter.
The table is unsorted.
2. I wish to assign the invoice number automatically serially to the
bills generated.
Any help will be greatly appreciated.
thanks,
rajesh


--
rajeshparikh64
------------------------------------------------------------------------
rajeshparikh64's Profile: http://www.excelforum.com/member.php...o&userid=32830
View this thread: http://www.excelforum.com/showthread...hreadid=526314