I have two excel sheets/tabs. One is labeled "names" and contains a list of names, the other is labeled "details" and has the same list of names (in a different order), as well as an age and color in the same row as the name.
Is there a way that I can write a comment or hyperlink (or any other type) code that will work such that, if I scroll over or click (for example) the name "Samantha" in the names sheet, the code will extrapolate from the details sheet and display the information in the same row as the name "Samantha", such as "29, Purple", without redirecting to any other cell.
Thanks!