Auto Populate

[young one]

I have a large spreadsheet in Excel with lots of
information (the first column is the ID number. the next
few columns contain information). I would like to create a
seperate form that will:
1. Allow me to type in an ID number
2. Then the program will auto populate the form with
appropriate information related to the ID number.

How can I do this?

Thanks for any help.

 

[RagDyer]

Look in the Help files for the Vlookup() function.

As a quick primer:
Data List on Sheet2,
A1100
Labels in Row1
ID number in ColumnA
Misc. data in B

On Sheet1,
Enter ID number in A1,

Enter this formula in B1:

=VLOOKUP($A$1,Sheet2!$A$2:$D$15,COLUMN(B1),0)

Then click on B1, and drag the fill handle across the columns to copy the
formula as fasr as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a large spreadsheet in Excel with lots of
information (the first column is the ID number. the next
few columns contain information). I would like to create a
seperate form that will:
1. Allow me to type in an ID number
2. Then the program will auto populate the form with
appropriate information related to the ID number.

How can I do this?

Thanks for any help.

 

[Gord Dibben]

Check out help and examples for VLOOKUP Function.

Insert a blank worksheet. Sheet2 in this example.

On Sheet1 where you have your table in say columns A through E select the 5
columns and Insert>Name>Define. Call it MyTable.

Now go to Sheet2 and in B2 enter

=VLOOKUP(A2,Sheet1!MyTable,2,FALSE)

A2 is where you enter the ID number

MyTable is the lookup table on Sheet1.

2 is the column in the table.

As you copy the formula across from column B to E on Sheet2, increase the
number 2 to 3,4,5 as in MyTable,3,FALSE

Gord Dibben Excel MVP