Excel Job by drmmpeer

excel dental invoice software- i need to be able to type a code and the price shows in the next column. Ive uploaded the codes and prices but other medical aids have different prices but the codes are the same. I would like to be able to select the medical aid and the correct price shows(they differ by a few percent only). If possible even saving patients names and details for recall later treatments. In the DAILY PATIENT LIST columns you will see MEDICAL AID column. There are about 30 different medical aids and each have their own price. A dropdown list would be great.