B Bonnie Apr 23, 2010 #1 I am creating an inpatient log and need the Name and Address fields to automatically pull in when the ID # is entered.
I am creating an inpatient log and need the Name and Address fields to automatically pull in when the ID # is entered.
E Eduardo Apr 23, 2010 #2 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))
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))
