Match name colums and paste corresponding values

[sumit]

Hello ALL,

This is my first post.

I have three colums A C D. In column A I have a list of name in asc
order. In colum C I have a list of name and with it i have associated
times values in column D.
I want to compare the colums A and C and where it matches want to place
the value in the column D in column B.

I have searched for it but could not find the solution.

 

[Roger Govier]

Hi

Try entering in B1
=VLOOKUP(A1,C,2,0)
and copy down as far as required.

or did you mean
=IF(A1=C1,D1,"")
and copied down