Excel 2000 - To have connected data appear in other parts of the worksheet

[HtoOh]

Sorry, I have forgotten how to do this. I have created a song worksheet in Excel 2000. From this list I have created set lists for different genres of music. I need the key (A-G#) connected to the song to automatically update in all song lists if I change it on the original list, even if the set list is on a different page. Would someone be so kind to remind me how to do this? Thank you.

 

[cyrilbrd]

Hi,

Are you referring to a lookup (vlookup would do fine in Excel 2000)?
the VLOOKUP would require the the cell where the song is, the range where the list is (list being song name AND key) and would return the Column where the key is (here "2" for second Column).
Is this what you needed?