FILL IN DATA USING KEY VALUE

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..
 
G

Gord Dibben

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
 

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

Displaying zeros in cells 2
Series fill only copying and fill series greyed out 1
Excel VBA 1
Fill data from row to column 2
Adding fill to cells only when value is "No" in another cell 1
Fill Down command Question 2
Links in Excel 4
Reference the same cell based on tab name 1

Top