FILL IN DATA USING KEY VALUE
 

CAN I TYPE A NUMBER IN A CELL THEN HAVE EXCEL SEARCH ANOTHER WORKSHEET FOR
THAT NUMBER THEN FILL IN THE DATA FROM THAT LINE INTO
MY NEW LINE. PROBABLY NOT..

FILL IN DATA USING KEY VALUE
 

Most assuredly.......yes

Check out VLOOKUP in help

Basics are you need an input cell with a value to lookup and table to look
in and a series of VLOOKUP formulas to pull the info.

Sheet1 A1 is your input cell.

Sheet2 $A$1:$F$100 is your table with values to lookup in column A

In Sheet1 B1 =VLOOKUP($A1,Sheet2!$A$1:$F$100,2,FALSE)

Copy across to F1 and edit the 2 to 3 to 4 etc.

To copy across without editing use this in B1

=VLOOKUP($A1,Sheet2!$A$1:$F$100,COLUMN(),FALSE)

Enter a value in Sheet1 A1


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 16:26:00 -0700, oregon62
wrote:

CAN I TYPE A NUMBER IN A CELL THEN HAVE EXCEL SEARCH ANOTHER WORKSHEET FOR
THAT NUMBER THEN FILL IN THE DATA FROM THAT LINE INTO
MY NEW LINE. PROBABLY NOT..