VBA to Vlookup cell text and return value as Cell Comment

Yes, that worked like a charm! Sorry the reason it was not returning matches is because the cell text was slightly different and in a different column. But the code works perfectly for returning the comment. The only thing was that it returns the comment for every cell. Do you know how to return the comment only for the first instance of that cell text? For example, if the cell text was Deepwater Asgard it would only return it for the first instance but every other time Deepwater Asgard is in the column then no comment is entered.

Thanks but is there a reason why you took the vlookup function out of the second set of code? I don't think it will work without a vlookup function and I am having trouble merging your first and second sets of code. I think in my OP i stated the wrong column which is why I suspect you removed the vlookup function. I was trying to lookup column B in data sheet and return column B in the array on the Mapping sheet. I don’t see how that could be done without a vlookup. I am trying to re-attach the spreadsheet to show you the desired result but its not letting me attach anymore.

I'm not seeing anything when I run the second set of code. I tried copying the contents of column B into Column A on the data sheet and then tried again to run the macro this is the result:


Second Set of Code.PNG

However, this is the desired result (I manually created this):

Desired Result.PNG

I should also point out that the difference between the rig names between the mapping sheet and data was an extra underscore at the end of each name which is why the original vlookup didn't return any results. I removed that underscore in the mapping sheet when I run the macro in the above screenshots.

Originally Posted by davesexcel

I don't know why you can't upload a new wb, possibly it is too large of a file or maybe you are trying to upload a file with the same name?

Okay, I figured out how to attach the corrected file in the original post. Sorry for the confusion.

Originally Posted by bakerman2

Did you try the code in Post#10 ?

Sorry, I scrolled to the end and missed your post. Yes! This works. Thank you, sir!