How do I copy columns between worksheets if the columns don't matc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 worksheets in which I have to copy one column of cells from one to
the other. The problem is that the "main" worksheet lists nearly 3,500
clients and I have to copy numbers into the "main" worksheet on weekly basis
from another worksheet that lists only about 1,100 of those 3,500 clients.
Both client lists are in alphabetical order, but I obviously cannot just copy
one column into the other, because then the numbers won't be matching the
correct clients.
 
Hi Miriam, do you need to copy or is possible to do it by a vlookup function?

regards from Brazil
Marcelo

"Miriam" escreveu:
 
whatever will work

Marcelo said:
Hi Miriam, do you need to copy or is possible to do it by a vlookup function?

regards from Brazil
Marcelo

"Miriam" escreveu:
Click to expand...
 
so, why not to copy the all column and get the other data with vlookup?

"Miriam" escreveu:
 
I guess I do not know what vlookup is.

Marcelo said:
so, why not to copy the all column and get the other data with vlookup?

"Miriam" escreveu:
Click to expand...
 
sorry, imagine that you have a worksheet like this:

COL A B C
Name ID status
Miriam 123456 1
John 145787 2
Mary 156578 4


in another worsheet you need to the 3rd column information, the A column as
the same.

COL A B
Name Status
Miriam =vlookup(a2;sheet1!A2:C3,3.0)
John
Mary

it will return 1 on b2

Note the VLOOKUP found the a2(Miriam) on the range A2:C3 on the Sheet 1, and
return the 3rd column.

hope this helps
regards
Marcelo





"Miriam" escreveu:
 
If you don't mind giving me a few more minutes of your time, I would like to
give you an example of the problem;

This is worksheet 1 (this is a master list of Agents and Codes):

A B C
AGENT'S NAME CODE AMOUNT DUE

1201 FINANCIAL 10541-N $-
1ST GLOBAL INSUR. SERVICES 640 $-
1ST PROFESSIONAL 396 $-

This is Worksheet 2 ( this is updated weekly with amounts due from Agents):

Agents Name code Current Amount Due
1201 FINANCIAL& 10541- $216.24
1ST GLOBAL 640 $3.33
A. K. J. LTD. 5506 $28.56

I need Column C from Worksheet 2 to merge with Column C in Worksheet 1, with
the correct dollars going with the correct agents. Otherwise, the dollars
have to be manually input every week.

Thanks
 
ok try to put on the column C from the WS 1 this formula

=Vlookup(a3,worksheet2!$a$1:$c100,3,0)

Assuming that your data on the ws 2 is on range a1:c100, excel will in a
vertical order look for the name of agent that is on A3, when it found return
the value of the 3rd collum, or $216.24 in the case of 1201 Financial&

Miriam Hope this helps
regards from Brazil,
Marcelo

"Miriam" escreveu:
 
Hi, we still have not figured it out. Is there any way I can e-mail you the
spreadsheets and you can take a look at them?

Thanks
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copying info from worksheet to worksheet if info matches 2
Find match between cells and copy data 7
how to automatically update a second worksheet when data inserted 2
COPY SUM FORMULAS TO SEVERAL OTHER WORKSHEETS 3
Help? with extracting unsorted data from a worksheet, no blank lin 4
How can I copy the sum of a filtered column into a cell in anothe 1

Back
Top