msarrasin5
New Member
- Joined
- Apr 18, 2019
- Messages
- 2
I have a file A that contains a column of 50 patient IDs for which I need the matching doctor. I have a file B that contains a column of patient IDs, including those I'm looking for, and a column of associated doctors (as well as other columns). Each column in file B has 3000 values.
For each ID in file A, I want to find the same ID in the ID column in file B, and return the doctor name in the same row to the field next to the ID column in File A.
I'm using the 2 file example for clarity but I understand the entire function can/would be done in one file
What is the correct function and how would I do it?
For each ID in file A, I want to find the same ID in the ID column in file B, and return the doctor name in the same row to the field next to the ID column in File A.
I'm using the 2 file example for clarity but I understand the entire function can/would be done in one file
What is the correct function and how would I do it?