Hello all, I was wondering if it's possible to have a VLOOKUP and a VLOOKUPCOMMENT in a single cell getting information from another sheet(I'm calling it my Master Sheet)?
Hello all, I was wondering if it's possible to have a VLOOKUP and a VLOOKUPCOMMENT in a single cell getting information from another sheet(I'm calling it my Master Sheet)?
Last edited by Vinny4$; 08-21-2020 at 11:44 AM.
What do you mean by VLOOKUPCOMMENT?
Hi Pepe, I would like to add an automatic 'Comment' to show up when someone hovers over the cell
Below is my current formula, it works great but I thought I could also add to it a 'Comment' when someone goes over the cell
=VLOOKUP(C3,Master!$A$2:$B$9789,2,FALSE)
Where would these VLOOKUPCOMMENTS come from? Would then be in Column C of Sheet Master?
This would require VBA to pull those comments and place them into "comments"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
ok, I understand, I did create a VBA to pull the required info, but, it is possible to add it in the same cell where I already have a VLOOKUP for the individuals name?
Here is something you can practice with
set up a blank workbook before using it in your actual wb.
addcomment.jpg
This will be the code to use.
Please Login or Register to view this content.
This is great, I will try tomorrow, too long of a day today.
TY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks