matching values
 

Newbie looking for code that would search column A find a matching value in
column C return
the value found in adjacent column D to column B.

Thanks.

matching values
 

Put this in B1 and copy down........

=VLOOKUP(A1,C:D,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"italiavb" wrote in message
. ..
Newbie looking for code that would search column A find a matching value
in
column C return
the value found in adjacent column D to column B.

Thanks.

matching values
 

Thanks a lot Chuck, It worked perfectly.
Pat

"CLR" wrote in message
...
Put this in B1 and copy down........

=VLOOKUP(A1,C:D,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"italiavb" wrote in message
. ..
Newbie looking for code that would search column A find a matching value
in
column C return
the value found in adjacent column D to column B.

Thanks.

matching values
 

Happy to help,..........and thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"italiavb" wrote in message
. ..
Thanks a lot Chuck, It worked perfectly.
Pat

"CLR" wrote in message
...
Put this in B1 and copy down........

=VLOOKUP(A1,C:D,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"italiavb" wrote in message
. ..
Newbie looking for code that would search column A find a matching
value
in
column C return
the value found in adjacent column D to column B.

Thanks.