+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP a range on mouseover?

  1. #1
    Registered User
    Join Date
    12-20-2016
    Location
    United States
    MS-Off Ver
    2016
    Posts
    40

    VLOOKUP a range on mouseover?

    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:

    Please Login or Register  to view this content.
    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.

    Is this possible? Thanks so much everyone!

    -Andrew

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: VLOOKUP a range on mouseover?

    If you information is fairly static, then you could write a macro which populates comments which contain the VLOOKUP information for each cell. Comments appear on a hover if you have it set to do so. For a more dynamic approach, check out this page that explains how to exploit HYPERLINK into a mouseover event which you could use then display data. It's messy.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. chart MouseOver grabbing Pòints to Range
    By doriangrey in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-06-2017, 11:42 AM
  2. Code Optimization for Inserting Comment for Mouseover Using VLookup
    By slice723 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2017, 10:40 PM
  3. Help with MOUSEOVER
    By aca in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2013, 07:33 AM
  4. Replies: 6
    Last Post: 09-04-2012, 10:35 AM
  5. mouseover ??
    By thinkglad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2008, 01:00 PM
  6. MouseOver Substitute in XL
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2006, 11:15 PM
  7. [SOLVED] VLOOKUP with mouseover?
    By Cheese in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2005, 12:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1