FILL IN DATA USING KEY VALUE

  • Thread starter Thread starter oregon62
  • Start date Start date
O

oregon62

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..
 
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
 
Back
Top