moving information associated with random selection.

[cflyte]

Hi all,
First time here.
I shall try to be brief and concise with my inquiry.
I have three columns set up with song title, key and page #.
I am able to randomly select a group of songs from the list for a performance.
Is it possible to have the key and page # relevant to the randomly selected song displayed alongside the song?


e.g. random selection is Brown-Eyed Girl. I need the key and the the page # to appear as well.

Column A Column B Column C
Brown-Eyed Girl G page 35

Bit of a long shot but here's hoping.

Thankyou.

 

[VoG]

Try VLOOKUP Excel VLookup Function Examples

 

[cflyte]

Try VLOOKUP Excel VLookup Function Examples

Thankyou - works a treat and so simple.

Kind regards