Dynamic tooltip acting as a vlookup

[gazmoz17]

Hi,

Can a Tooltip replace the below formula.....which takes me to a diff tab looking up the corresponding Nominal code name form Nominal code clicked in column I?

=IFERROR(HYPERLINK("#'NC'!A"&MATCH(H28,NC!A:A,0),H28),"")

Currently when I click I24 it will take me to corresponding nominal code in work sheet "NC" Table name "NC".

Is there a way I can hover over I24 and will tell me the "Name" value in column B above. So the hover would return "Materials Purchased"?

Many Thanks
Gareth

 

[sijpie]

It would be possible, but I am not sure if it is going to be a neat solution.
On activating the sheet (selecting it), a macro could run that updates the notes attached to each cell that needs this hover_above facility.
These cells will then get the little red corner. When hovering over the cell, the note will show.

Another way is to use shapes over the cells. See this thread: How can I trigger an Excel macro by hovering a mouse over a cell?