Associate a cell with a number ??

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

jladika

hello
i work in a medical center all of my patients have been given
patient ID # Mr Smith = 276


is there a way that all i have to do in column "a" is put "276"
and in the same cell in column "b" Mr. Smith name will show.


jo
 
not sure of what is going on
i cant find this in the room


could someone tell me if this is possible?
please help me ou
 
Hi jladika!

Here's a simple example of what Frank has recommended:

J1: 94
J2: 67
J3: 43
K1: Smith
K2: Jones
K3: Johnson

A1: 67
B1:
=VLOOKUP(A1,$J$1:$K$3,2,FALSE)

The arguments for VLOOKUP:
A1 is the cell to look up
J1:K3 is the table to be looked up which has been absolutely
referenced so as to allow the formula to be copied elsewhere. The
values in column 1 of the table are the values that will be looked up;
in your case the patient numbers.

2 is the column of the table that you want to return; you might have
different data other than names in other columns.
FALSE tells the formula to look up exact matches only.

Now for fuller details it's off to the reference Frank gave you:

http://www.mvps.org/dmcritchie/excel/vlookup.htm
 
Hi jladika!

Follow the very basic example I gave in my last post. I gave a simple
VLOOKUP table in J1:K3 with a formula that uses it in cell B1.

Once you get the hang of how it works you'll be able to extend it to
cover large numbers of records and indeed will be able to pull out
other data from the lookup table.

I'll send you a sheet if you need more help. Just send email to
address below.
 
Back
Top