Copying info from worksheet to worksheet if info matches
in [Functions]
|
From: Carrach on 5 May 2010 10:22 Hi there, would be grateful for any help. I have a very large workbook with many linked sheets. I would like to copy info from worksheet to worksheet if the information matches: sheet1 (new clients), column A (company name), column J (sector) Sheet2 (baseline info), column A (company name), column L (sector) If I add a company name into sheet2 I would like sheet1colA searched for the matching company name and the information from sheet1colJ of the matching row to be automatically populated into sheet2colL. e.g if Fred Bloggs Ltd, music (sector) in sheet 1 then Fred Bloggs Ltd in sheet 2 should automatically become (sector) Music. -- any help gratefully received thanks carrach
From: Eduardo on 5 May 2010 12:24 Hi, in column L sheet 2 enter =index(sheet1!$J$1:$J$10000,match(a1,sheet1!$A$1:$A$10000,0)) "Carrach" wrote: > Hi there, > would be grateful for any help. > I have a very large workbook with many linked sheets. I would like to copy > info from worksheet to worksheet if the information matches: > sheet1 (new clients), column A (company name), column J (sector) > Sheet2 (baseline info), column A (company name), column L (sector) > > If I add a company name into sheet2 I would like sheet1colA searched for the > matching company name and the information from sheet1colJ of the matching row > to be automatically populated into sheet2colL. > e.g if Fred Bloggs Ltd, music (sector) in sheet 1 then Fred Bloggs Ltd in > sheet 2 should automatically become (sector) Music. > > > > > -- > any help gratefully received > thanks > carrach
From: Carrach on 6 May 2010 04:52 Hi Eduardo, thanks for the help but it is not working I am getting N/A# I thought it might be an array so tried with CSE but to no avail. I'm working in excel 2003 does that make a difference?? -- any help gratefully received thanks carrach "Carrach" wrote: > Hi there, > would be grateful for any help. > I have a very large workbook with many linked sheets. I would like to copy > info from worksheet to worksheet if the information matches: > sheet1 (new clients), column A (company name), column J (sector) > Sheet2 (baseline info), column A (company name), column L (sector) > > If I add a company name into sheet2 I would like sheet1colA searched for the > matching company name and the information from sheet1colJ of the matching row > to be automatically populated into sheet2colL. > e.g if Fred Bloggs Ltd, music (sector) in sheet 1 then Fred Bloggs Ltd in > sheet 2 should automatically become (sector) Music. > > > > > -- > any help gratefully received > thanks > carrach
|
Pages: 1 Prev: Counting for frequency Next: sum 2 values in diffnt cells with dup values, and sum if not dup |