Excel: locate value in one list & copy

[Solved/Closed]
Report
-
 Brad -
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Many Thanks, Rizvisa1.
It works perfectly.
THANK YOU SO MUCH! You saved my life today with the above formula.