Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.123quattro,microsoft.public.excel.printing,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
fairly basic excel question (i hope)
I don't have any VBA skills but need to combine data from two excel
lists. one list (A) has 7000 records with many fields against each unique company, the other list (B) has about half this amount of the same unique companies (all on original list) but 3 additional fields that I need to import into the main dataset. So basically is it possible to set up a formulae that says "If company name in data set B1 = any company name in data set A then import fields B2, B3 B4 into dataset A against matching company name - without disturbing the other fields in A. Any help greatly appreciated as I asked someone to do this manually and lost much of the data and much time and now well behind. mibro |
#2
Posted to microsoft.public.excel.123quattro,microsoft.public.excel.printing,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
fairly basic excel question (i hope)
Assume the next open column is M, so in M2 on the sheet with 7000 companies,
put in a formula =vlookup(A2,Sheet2!A2:D3500,2,False) in N2 =vlookup(A2,Sheet2!A2:D3500,3,False) and in O2 =vlookup(A2,Sheet2!A2:D3500,4,False) These would get the values in columns B, C, D of Sheet2 You can then select these three cells and drag fill down the column if a match is not made, you get #N/A select M:O, then do Edit=goto = Special, select formulas and Errors and do Edit=ClearContents Now select M:O, do Edit copy, then Edit=Pastespecial and select Values. this will replace your formulas with the results. -- Regards, Tom Ogilvy "mibro" wrote in message om... I don't have any VBA skills but need to combine data from two excel lists. one list (A) has 7000 records with many fields against each unique company, the other list (B) has about half this amount of the same unique companies (all on original list) but 3 additional fields that I need to import into the main dataset. So basically is it possible to set up a formulae that says "If company name in data set B1 = any company name in data set A then import fields B2, B3 B4 into dataset A against matching company name - without disturbing the other fields in A. Any help greatly appreciated as I asked someone to do this manually and lost much of the data and much time and now well behind. mibro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Templete question...I hope there is an answer | Excel Worksheet Functions | |||
VLOOKUP() Question... i hope | Excel Discussion (Misc queries) | |||
Beginner question (I hope) | Excel Programming | |||
Basic Excel Question | Excel Programming | |||
Basic Question of Excel | Excel Programming |