How to see a cell's reference value displayed as text when a cell is selected. (phone Usable)

[Dermot]

Can I see a comment or a similar text display setting display the cell's reference value whenever I select that cell?

So if I have a column A for example having the values shown below, I would want to see the name values next to column C displayed when I select each cell in column A.

Note, I will be using a phone to do this, so i don't think a vba code solution can work.

the user will be entering the number values ( in column A), so the name display (in column D) should be seen after every entry.

eg. cell containing "141" display "Dermot" selected.

Column A column B
141 $ 600.00
30 $ 300.00
94 $ 3,000.00
67 $ 3,000.00
329 $ 300.00


Column C Name
141 Dermot
30 Johnson
94 Lesa
67 Meliesa
329 John

 

[rahulshewale1]

hi,


See if it is ok ?

 

[vletm]

Dermot
Check my reply from Your original 'same' case...
https://chandoo.org/forum/threads/e...cell-to-display-data-without-using-vba.41050/
... hmm?
Seems that You've changed some details
... that means windy
... and double work!

 

[Dermot]

hi,


See if it is ok ?

No this is not what I'm looking for.

 

[Dermot]

hi,


See if it is ok ?

Okay, I am now understanding your solution. This is not really what i am looking for, the name values here would "crowed" the sheet, and would not look as neat. I just need a little 5 or 6 seconds name display whenever I select/hover the number of the relevant cell (after it is entered). Thank you for your input though, it is notable.