Hi everyone! I'm trying to add some convenience to a spreadsheet without adding more columns to do a normal VLOOKUP formula over thousands of rows on multiple worksheets. I've tried searching all over this morning to find someone doing this and no luck so far.
What I'm to do it this:
In column 7 ("G"), starting in row 2, I'd like to perform a VLOOKUP to a named range that I have on another worksheet. There are about 14 worksheets, with over 4,000 rows each, that I'd like to apply this to, and they each will point to the same named range for the VLOOKUP. But I'd like the result of the VLOOKUP to be in some sort of "bubble" that appears on hover/mouseover of each cell in G2:G4100 (or $G:$G could work as well).
So if I hover over the text in cell G7 on a given worksheet, if the value of the cell is not blank or not a value of "N/A", it would do a VLOOKUP to find the matching data in column 1 of the named range (in the separate worksheet), and then the bubble would give me the result of column 2 of the named range. Basically, the equivalent of the below formula for all cells in column G of all worksheets, but in a bubble on mouseover of any cell in column G:
I'm totally fine with pasting the same code in all 14 sheets.... that's not a problem at all. And that would probably be best, since there are a few worksheets that I don't need to apply this to.Please Login or Register to view this content.
Is this possible? Thanks so much everyone!
-Andrew
Bookmarks