NEED HELP

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?
 
G

Gary''s Student

First you must create a master list of record numbers vs names.

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