| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying info from worksheet to worksheet if info matches
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying info from worksheet to worksheet if info matches
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying info from worksheet to worksheet if info matches
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting info from one worksheet to another | Excel Discussion (Misc queries) | |||
| Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
| Info from worksheet to worksheet pulling from list | Excel Discussion (Misc queries) | |||
| Display info from a worksheet into another worksheet | Excel Discussion (Misc queries) | |||
| Copying info entered on one worksheet automatically to another | Excel Discussion (Misc queries) | |||
Linear Mode
