Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Fill | Excel Discussion (Misc queries) | |||
Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
fill data | Excel Discussion (Misc queries) | |||
Fill in data if | Excel Discussion (Misc queries) | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) |