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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Cells 3
Auto fill not working 2
VBA - If / And Statements 1
Shorten Formula 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Access Automatically Send a notification email once a record is added 0
Find last date from one table prior to date from another table? 3
may be crosstab will do the job 2

Top