Excel: locate value in one list & copy

Solved/Closed
Tut - Jul 19, 2010 at 11:29 AM
 Brad - Oct 26, 2011 at 06:31 PM
Hello,
I need some help with Exel. I have two lists:
List one contains two coulmns: ID numbers and age.
List two contains also two coulms: ID (some from list 1) and their running time in a race.
I want to have in List one an addtional (third) coulmn - RunTime with the matching runtime for the IDs. If ID in list one does not have a corresponding runtime in List two a "." value will be assigned.

Can someone help me with this task?
Many thanks in advance,

Tut

List One . . . . . List Two
ID Age RunTime . . . . ID time
11 17 . . . . . 29 10.3
12 16 . . . . . 15 10.6
13 20 . . . . . 22 11.9
14 13 . . . . . 12 12.1
15 15 . . . . . 26 14.5
16 32 . . . . . 14 15.7
17 15 . . . . . . .
18 15 . . . . . . .
19 47 . . . . . . .
20 44 . . . . . . .
21 32 . . . . . . .
22 42 . . . . . . .
23 15 . . . . . . .
24 19 . . . . . . .
25 14 . . . . . . .
26 45 . . . . . . .
27 45 . . . . . . .
28 21 . . . . . . .
29 44 . . . . . . .
30 22 . . . . . . .



1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jul 19, 2010 at 12:21 PM
you can use vlookup

Lets say List 1 is between col A-C and list 2 is column D-E

then in C2 you can have

=IF(ISERROR(VLOOKUP(A2, D:E, 2, false)), ".", VLOOKUP(A2, D:E, 2, false))
and just drag it down
1
Many Thanks, Rizvisa1.
It works perfectly.
0
THANK YOU SO MUCH! You saved my life today with the above formula.
0