If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
EXCEL
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. |
#2
|
|||
|
|||
EXCEL
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" wrote in message ... 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. |
#3
|
|||
|
|||
EXCEL
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 |
Thread Tools | |
Display Modes | |
|
|