Help with how to get the data please

[Surreyview]

Good Morning,

I have two spreadsheets:
1. Is a master file of 10,000 cutomers that contains all information such as name, ID, address, payment schedule, price charged, item brought
2. Is a file that has some information in, but has lots of missing data.

I want to use file 1 to populate file 2, specifically I want to
1. look up the patient ID file 2 and locate it in file 2
2. filter by a specific item purchased within file 2
3. and insert the price charged from file 1.

How do I do this? Is it possible?
thank you

 

[Surreyview]

Yes, I think you are right.

 

[Gerald Higgins]

In that case something like this should work.

Assumptions -
On your Patient Data sheet, the Patient ID is held in column B, with value 99999 appearing in cell B2.
On your Master Data sheet, the Patient ID is held in column A, with value 99999 appearing in cell A2.

Put this somewhere on your patient data sheet, perhaps in column F, or a new column that you insert to the right of col F if you want to retain those values just to be safe.

=VLOOKUP(B2,'Masterr Data'!A$2:E$5,5,FALSE)

and copy down as far as required.

 

[Surreyview]

I cannot thank you enough for helping me with this, THANK YOU

 

[Gerald Higgins]

hth, tftf