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
Bookmarks