Add Comment Based on adjacent cell value (vlookup?)

Hello all,

So I have been browsing all morning and have yet to find anything that I've been able to modify for my use. So here goes and I appreciate all help!


I have a sheet ""project" that has customer #'s in Column A and then several columns of various data that is pulled in from other hidden sheets.

One of those other sheets is a rebate detail - it has two columns, A & B. A is customer # and B is concatenated info of all the types of rebates (it has been pasted as a text/value so no formula).

I would like to create a comment box on my original sheet (project) that would appear in Column AB that returns the results of a vlookup on the customer number from column A. I want to do a comment box, because that cell already has a formula result in it and I don't want to modify that cell, just add the comment as supplemental info.


I've found a few items that were close - but nothing that I've been able to manipulate. I'm new to VBA and have done simple formatting and search macro's but nothing like this, I thought it would be easy haha.
Any help is appreciated - I hope that was clear?

THANK YOU!

Thank you for response -

I've stripped out most of the info and uploaded the basic sheet (minus formatting). I appreciate your help and any additional detail you can offer would be awesome!

Trying to add the comment box to column AE based on the Account # (Column A) with info from the "Rebate Info" sheet.

I'm an newbie when it comes to VBA - I know how to read it and understand what's going on - but writing it is completely foreign to me (but I'm getting better - I hope?) I understand everything you posted but I'm not sure how to expand/apply it to the entire columns of the workbook.

Dude!
So, that works perfectly on the sample sheet I uploaded - thank you! That is exactly what I was looking for.

I'm having some glitches/difficulty implementing it in the full file with all data - I'm going to try and work through those for a bit. Thank you for the comments in the code as well huge learning tool - that was perfect.

Thanks again. I may reach back out if I'm unable to resolve the minor glitches in the full file. But otherwise - perfect.

Thanks again.

Arkadi - worked out my bugs. Just needed to change some of the Sheet references in the vlookup. My original file was not sheets 1 & 2 - it was more like sheet5 & sheet14. But all good now! Thank you for the help!