Is this possible??

[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

 

[Norman Harker]

See the answer just given to your first posting.

 

[jladika]

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

 

[Frank Kabel]

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)

 

[jladika]

THANKS AGAIN FOR YOUR HELP

JO