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.
--
Gary''s Student - gsnu200789


"JJ" wrote:

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?