NEED HELP

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

I know this might be easy but, I have a worksheet that has Medical Record
numbers in the first column followed by patient's name in the second column.
How do I adjust my worksheet so that if I type in the Medical Record number
it will automatically place the patient's name in the second column? Can that
be done?
 
First you must create a master list of record numbers vs names.

Then you can use VLOOKUP() to pull names off hte list.
 
Back
Top