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

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