Match name colums and paste corresponding values
 

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.

Match name colums and paste corresponding values
 

Hi

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

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

--
Regards

Roger Govier


"sumit" wrote in message
oups.com...
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.