Copying info from worksheet to worksheet if info matches

C

Carrach

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

Eduardo

Hi,
in column L sheet 2 enter

=index(sheet1!$J$1:$J$10000,match(a1,sheet1!$A$1:$A$10000,0))
 
C

Carrach

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??
 

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

VBA Coding Help for Beginner 0
Copy entire row from another sheet onto first sheet if a unique text matches 1
Integrating information from Word to Excel (not mail merge) 1
matching & combining data from seperate worksheets 2
Need to match 2 columns, if a match found add info from 2nd column 1
Worksheet formula - auto populate 4
What is the best way to lookup from another worksheet? 0
Automatically populate cells based on info in another worksheet 2

Top