Match Data

  • Thread starter Thread starter Donna
  • Start date Start date
D

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
 
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
 
Back
Top