Keep values after lookup

M

MABeatty

What I am looking to do is perform a lookup on some values from one
worksheet into another. However, after the values are looked up i want
to be able to paste new data into the souce sheet, but retain the
origianl values

Example
I would like to merge the value in the source sheet (4,5,5) into the
destination under "Apr". And then past new data into the source while
keeping the original 4,5,5. There are not always the same number of
people so a simple Sort/Copy/Paste will not work

Source
Score
Smith 4
Johnson 5
Howard 5


Destination
Jan Feb Mar Apr
Smith 3 6
Brown 3 3
Johnson 5 2 6
Howard 5 2
 
P

Paul Lautman

MABeatty said:
What I am looking to do is perform a lookup on some values from one
worksheet into another. However, after the values are looked up i
want to be able to paste new data into the souce sheet, but retain the
origianl values

Example
I would like to merge the value in the source sheet (4,5,5) into the
destination under "Apr". And then past new data into the source while
keeping the original 4,5,5. There are not always the same number of
people so a simple Sort/Copy/Paste will not work

Source
Score
Smith 4
Johnson 5
Howard 5


Destination
Jan Feb Mar Apr
Smith 3 6
Brown 3 3
Johnson 5 2 6
Howard 5 2
Click to expand...

Select the column then Copy and Paste Special->Values
 

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

Multiple instances of lookup value 3
Lookup, index, match, range, oh my... 1
Lookup value and return column offset value 5
Look up in another sheet for values to return in 1st worksheet 2
Database 1
simple formula I'm sure using offset? or index? 2
Lookup range help 2
adding cells upto and including a specified cell 6

Top