Auto Fill
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$10 000))
in C enter
=index(Data!$C$1:$C$10000,match(a2,Data!$A$1:$A$10 000))
"Bonnie" wrote:
I am creating an inpatient log and need the Name and Address fields to
automatically pull in when the ID # is entered.
|