Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep values after lookup
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 -- MABeatty ------------------------------------------------------------------------ MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258 View this thread: http://www.excelforum.com/showthread...hreadid=521842 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep values after lookup
MABeatty wrote:
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 Select the column then Copy and Paste Special-Values |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning multiple corresponding values using lookup in a list | Excel Discussion (Misc queries) | |||
How do I use Lookup to return a row of values eg. 6 cells | Excel Worksheet Functions | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
How do I lookup data with two comparison values? | Excel Worksheet Functions | |||
vlookup using two lookup values? | Excel Worksheet Functions |