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...

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.