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

VLOOKUP? SUMPRODUCT? not sure how to do this 4
Worksheet formula - auto populate 4
Automatically populate cells based on info in another worksheet 2
matching & combining data from seperate worksheets 2
Need to match 2 columns, if a match found add info from 2nd column 1
consolodating info from different sheets with different info 3
copy if data matches 3
Copy data that matches criteria in one worksheet to another worksh 1

Top