	AllExperts > Excel
	Search

About Aidan Heritage
Expertise
I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards

Experience
My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

Education/Credentials
I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!

You are here: Experts > Computing/Technology > Microsoft Software > Excel > Copy values from one sheet to the other

Excel - Copy values from one sheet to the other

Expert: Aidan Heritage - 11/9/2009

Question
I am having two excel sheets, W1 and W2. In W1 i have certain charecters and in W2 i have the 3 corresponding values for the charecters in W1

My Problem is that the text for the charecters are not the same in W1 and W2, but are more or less the similar. The second thing is that the values are not listed in the same order in W1 and W2.

I need to have a logic to arrange all the values for the charecters in Sheet W1. Manually this can be done, but since there are more than 5000 points it will take moe time and accuracy is less.

Answer
I’m not following what needs to be done here – can you clarify – if it helps, you can email me at aidan.heritage@virgin.net - it SOUNDS as though it may simply be vlookup that is needed - if it helps, there is a useful dictionary of excel terms at http://www.aidanheritage.byethost3.com/excel/xlfdic01.xls which includes worked examples of many of the functions in excel including this one.

Add to this Answer Ask a Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here