Matching records

[rireland]

I have many records from a card entry system with times & card number. I have another file with the name & card number. I want to combine the two so I have times & name. For example:
1234 12:43
2345 13:34
4567 14:56
1234 15:45

the other file has:

1234 John Smith
2345 Jill Jones
4567 Fred White

I want end up with:

1234 12:43 John Smith
2345 13:34 Jill Jones
4567 14:56 Fred White
1234 15:45 John Smith


Any advice - preferably not VBA - I'm a a novice & find excel formulas easier than VBA

 

[shadow12345]

Sure, you want a vlookup for that.

In the below I assumed that the staff id was in col A, the time in col B and you wanted the name in col C

(i didn't have the names and id's in another file i put them in col G and H, but you could)

Put this into Col C row 2
=VLOOKUP(A2,$G$2:$H$4,2)

 

[rireland]

Thanks for fast reply. If the times are in a file called "times" and the names are in file called
"names" and I wanted the merged data into a file called "results", what would be the formula I would put into the results file.

Thanks

Richard