Find String and Replace With Adjacent Cell

Hello,

I am trying to do the following. I have two sheets. In sheet one a have a column of data (A). In sheet two I have two columns of data (B and C). I want to match each cell in A to B, and then return the adjacent value in C. Can anyone help me do this? I have been struggling with the Find and Replace VBA function. Thanks.

Steve

Steve,

Give this a try:

Please Login or Register  to view this content.

Tiger this works great! Thanks for the quick and helpful response. I look forward to figuring out exactly how it works.

Steve

You're very welcome