| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Data
How can I match data for one employee that is in two or more spreadsheets?
Example: Spreadsheet 1 Employee Pay Rate 9657 15.00 Spreadsheet 2 Employee State 9657 IA Result needed Employee Pay Rate State 9657 15.00 IA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match Data
Put this in C2 of spreadsheet 1:
=IF(ISNA(VLOOKUP(A2,Sheet2!A:A,1,0)),"",VLOOKUP(A2 ,Sheet2!A:B,2,0)) Copy it down as required. Hope this helps. Pete On Apr 7, 8:41*pm, Donna wrote: How can I match data for one employee that is in two or more spreadsheets? Example: Spreadsheet 1 Employee * * * Pay Rate 9657 * * * * * * * 15.00 Spreadsheet 2 Employee * * * State 9657 * * * * * * * *IA Result needed Employee * * Pay Rate * * *State 9657 * * * * * * *15.00 * * * * * IA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
| Why do my data labels do not match source data? | Charts and Charting in Excel | |||
| Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
Linear Mode
