Match Data

[Donna]

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

 

[Pete_UK]

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