EXCEL
in [General]
|
From: Giselle on 15 Apr 2010 22:45 I have two different workbook with different data in each one except for the social security that might be in both workbook. I want to order excel that whenever they find in the workbook 2 any social security that exist in workbook 1 they trnslate the data to the workbook 1.
From: ozgrid.com on 15 Apr 2010 22:56 VLOOKUP or INDEX/MATCH. Write the Formula in Book2 and then Cut and move to Book1. http://www.ozgrid.com/Excel/excel-vlookup-formula.htm http://www.ozgrid.com/Excel/left-lookup.htm -- Regards Dave Hawley www.ozgrid.com "Giselle" <Giselle(a)discussions.microsoft.com> wrote in message news:E71EA0AA-322B-4A4C-92C2-1AF03FFC759F(a)microsoft.com... >I have two different workbook with different data in each one except for >the > social security that might be in both workbook. I want to order excel that > whenever they find in the workbook 2 any social security that exist in > workbook 1 they trnslate the data to the workbook 1.
From: Dave Peterson on 16 Apr 2010 07:59 Sounds like a perfect chance to learn about =vlookup() or =index(match()). Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble Giselle wrote: > > I have two different workbook with different data in each one except for the > social security that might be in both workbook. I want to order excel that > whenever they find in the workbook 2 any social security that exist in > workbook 1 they trnslate the data to the workbook 1. -- Dave Peterson
|
Pages: 1 Prev: What are the different methods of representing numerical data? Next: Issue with pivot table |