Hi,

1 way. Create a simple table like this
A B C
Doc Halliday 123 Doc Halliday
Doc Crippen 456
Doc Doolittle 789

In another cell type the formula

=VLOOKUP(C1,A1:B3,2,FALSE)

This looks for a name in C1 and returns the number next to that name from
the table.

Mike

"Learners of excel, access and databases" wrote:

How can I set up table list with doctor's last name first , with first name
initials and with their tittles. So that when you enter in a name of a doctor
their GP practice code comes up automatically within the adjacent cell?