Is this possible??

  • Thread starter Thread starter jladika
  • Start date Start date
J

jladika

i am looking for some help


i have a spreadsheet and i want to keep track of my patients

all of my patients are given ID# MR Smith =278

i would like in column "A" input the number "278"
and in column "B" same cell would like to see MR. Smith name come up.
not sure if this can be done
if so please help me with this problem

thanks

jo
 
i saw that site
but not a clue as to how to use it

could you please tell me how to do what i need
please

thanks jo
 
Hi Joe
to give you an idea:
1. create a lookup table on a separate sheet (call this sheet
'patients'). It should look like
A B
1 ID name
2 123 Mr. Smith
3 .....

2. Now lets say you have a second sheet and enter the ID of a patient
in cell A1. Enter the following formula in B1:
=VLOOKUP(A1,'patients'!$A$1:$B$200,2,0)
 
Back
Top