hello all,
On the "treatment" sheet I have some basic information about a patient that includes the patient registration number and the item code for the treatment they received. For the purposes of the reporting I need to maintain a separate line for each item of treatment but repeat all of the other information.
On the 'details' sheet I have all the patients details, address etc.
on the third sheet "combined" I have the information from "treatment" brought across into the format I need to keep it for reporting.
I need a formula which will look up the patient number on "combined" and draw the other patient details into the sheet from the "details" sheet.
I have attached a copy with dummy data in.
Please help, I have tried a variety of Vlookup and match functions and I cant seem to get it to work. I would just do it manually but in my version I have some 5000 lines on the "Treatment" sheet.
Bookmarks