Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Fill
I am creating an inpatient log and need the Name and Address fields to
automatically pull in when the ID # is entered. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
using auto fill edit or fill handel | Excel Worksheet Functions | |||
Auto fill box | Excel Discussion (Misc queries) | |||
auto filter and auto fill | Excel Programming |