VLOOKUP find, copy and paste

S

Stef

Hallo,
I am a very junior user.. so bear with me :O)

I need to do the following:

* In sheet 1, I have list of names, and in sheet 2 I have the same list of
names plus data regarding total revenue generated
* In sheet 1 I need to copy the total revenue generated, taking it from
sheet 2, through autofill. So it should look for the name match, copy the
relevant data on same row, and paste it in sheet 1

I hope this is clear...

thanks for your help in advance,
S
 
B

Bernard Liengme

Go to Help and read about VLOOKUP
Then come back if you have more questions
best wishes
 

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

Insert name and adress from a list in a word document 1
Summing across multiple columns 1
Match Copy/Paste Macro almost there 0
Create a dynamic master file 1
IF statement with multiple VLOOKUPs 0
Copy unformatted value of cell via macro 0
Copy a formula using Vlookup 2
VLookup or Macro? 0

Top