Prev: Excel Macro Problem
Next: Remove unnecessary rows
From: Bonnie on 23 Apr 2010 10:30
I am creating an inpatient log and need the Name and Address fields to
automatically pull in when the ID # is entered.
From: Eduardo on 23 Apr 2010 12:54
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))


"Bonnie" wrote:

> I am creating an inpatient log and need the Name and Address fields to
> automatically pull in when the ID # is entered.
 | 
Pages: 1
Prev: Excel Macro Problem
Next: Remove unnecessary rows