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 Word Documents 4
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
New Outlook problem 0
Auto Populate One Pages from spreadsheet 0
Hyperlinking automatic?? 1
Template with fields and premade texts.. 0

Top