Auto Fill

B

Bonnie

I am creating an inpatient log and need the Name and Address fields to
automatically pull in when the ID # is entered.
 
E

Eduardo

Hi,
I assume that the name (column B) address (column C) and ID (Column A)
number are in sheet called Data , then in the sheet called Log you want to
enter the ID in column A and pull the information in column B and C so in B
enter

=index(Data!$B$1:$B$10000,match(a2,Data!$A$1:$A$10000))

in C enter

=index(Data!$C$1:$C$10000,match(a2,Data!$A$1:$A$10000))
 
Top