|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
01-03-2007, 08:52 PM
|
|||
|
|||
|
Make this work?
Ok I need excel to do one or two things, to accomplish my goal.
I either need to make it do this: If column A in worksheet one corresponds with Column E in worksheet two, withing the same workbook, I need D,E,F,G of worksheet one to paste into D,E,F,G of worksheet two... Is there anyway to do that... I am new to excel sort of... At least this part... Or... I need it so I can use the find tool and find/replace multiple items at once but replace them all with the same thing. What would I use in the find box to seperate different things for it to find... I tried commas and colons... Last edited by mikhailia; 01-03-2007 at 08:52 PM. Reason: Typos 
|
|
#2
01-05-2007, 03:42 AM
|
|||
|
|||
regarding your first question, you can use VLOOKUP function to accomplish this task.
see the link below for understanding and using VLOOKUP function. http://www.contextures.com/xlFunctions02.html however if need more assistance regarding implementation of VLOOKUP, attach here a sample file. regarding your second question, you need to put more info about what you want to Find and Replace with (mention your criteria). Regards.
__________________
starguy PAKISTAN __________________ Forum Rules (read before you post) Links to the world of Excel
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
