| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data replacement between worksheets
I have a report coming in the form of a csv file, one of the columns has a
list of values which I need to cross reference against another column of values in a different worksheet and replace with the second value in the first worksheet. Is it possible to automate this process via formula etc. or can it only be done manually? If possible, how do you do it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data replacement between worksheets
Look at VLOOKUP function.
"JLB" wrote: I have a report coming in the form of a csv file, one of the columns has a list of values which I need to cross reference against another column of values in a different worksheet and replace with the second value in the first worksheet. Is it possible to automate this process via formula etc. or can it only be done manually? If possible, how do you do it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data replacement between worksheets
Thanks Toppers that has worked a treat.
"Toppers" wrote: Look at VLOOKUP function. "JLB" wrote: I have a report coming in the form of a csv file, one of the columns has a list of values which I need to cross reference against another column of values in a different worksheet and replace with the second value in the first worksheet. Is it possible to automate this process via formula etc. or can it only be done manually? If possible, how do you do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number replacement | Excel Discussion (Misc queries) | |||
| Replacement for sumproduct? | Excel Discussion (Misc queries) | |||
| #N/A Replacement | Excel Discussion (Misc queries) | |||
| replacement for IF function? | Excel Discussion (Misc queries) | |||
| Replacement | Excel Discussion (Misc queries) | |||
Linear Mode
