VBA Lookup one cell Value and Search in Another Column, if Matches Copy Beside Cell value

Dear Programmers,

I need small Modification in my code, i.e, Lookup one cell Value if Matches Copy Adjacent Cell Text to Another Cell

and required small modification and fixing minor bugs.

bug is some times at "S" Column produced as "0" instead of numeric values.kindly test my code. and some times are working, what happen to my code???


Thanking you,
Best regards

Dear all,

At T column May be like this?

Please Login or Register  to view this content.

i have inserted but showing errors. please guide me masters.

Thanking you,
Best regards.

I have posted similar thread at http://www.mrexcel.com/forum/excel-q...ther-cell.html

but still no solution.

Have a look.

Dear Masters,

Please solve my post.

Thanking you,
Best regards.

My Actual code is Like this:

Please Login or Register  to view this content.

Kindly modify and tweak if any to my present code as per Attached document.

Is this Impossible task?

I think while I suspect this might be straightforward - people don't understand what it is you are asking for.

Maybe you can simplify your question/example to show only the problem you want resolved?

Generally you can convert a text of 0 to a number by just adding 0 (i.e + 0) amongst other methods.
As to the rest you seem to be quite far from a solution I don't even know where you define Rw.... maybe you mean LR???