Help with a reference list to automatically generate details

[Sindagon]

Dear All,

This is my first post on this forum. I have racked my brains trying to come up with an adequate solution but I haven't been able to find one that works so far. My problem is as follows:

I have a database which includes a list of people's names, surnames and I.D. numbers (in that order, in colums K, L and M respectively). These are on a sheet named "EMTP". These entries I just mentioned can be repeated in more than one row. On another sheet named "Patient List" I have the reference list of individual people's names, surnames and I.D. numbers, in columns A, B and C respectively, which I want to use as a reference. I somehow want to link the information in the reference list to the main information on the "EMTP" sheet in a way that will allow me to input the I.D. number only (in column M), and have the associated information (name and surname) pop up automatically in the adjacent cells in columns K and L, IF the patient is already in my "reference list". If nothing pops up, I will know it is a new one so I will need to be able to insert it into my reference list for future use.

Would anyone be able to help me with this because I'm at my wit's end.

Kindest Regards,
Sindagon

 

[SteveO59L]

send me a pm, with your email addy and i will send you a worked example