R1C1 code returns "no match"

[tomscogg]

Hi all,

I am comparing data across two worksheets. The coding below returns a "no match" value in Worksheet3 Column E if one or more cells in a given row do not match exactly with Worksheet2

If value = "no match" in Worksheet3 then how can I tweek the code to make it return the correct corresponding data row found in Worksheet2. If a Data row in Worksheet3 cannot be found in Worksheet2 then a value of "not found" should be returned

Please Login or Register  to view this content.

thanks for your help

Cheers

Tom

[JosephP]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here