Formula help.

[Dan Wilson]

Good day. I am running Excel out of Office365 (updated) and Windows 10 Home (Updated). I have a workbook that tracks all of the songs in my music library. One of the worksheets is used to generate 40 random numbers between 1 and 3000. The worksheet titled "50-69" contains several Columns dedicated to the identification of each song in the library. Column A contains the song title. Row 1 contains the Column headers and is set as the "Freeze Top Row" for the worksheet. Thus, Rows 2 through 3000 identify each song. There is a separate worksheet titled "Sheet 1" that creates the random numbers in 40 separate cells as show below.

1​	2​	3​	4​	5​	6​	7​	8​	9​	10​
2611​	268​	2587​	2023​	348​	1505​	127​	1795​	2926​	1433​
11​	12​	13​	14​	15​	16​	17​	18​	19​	20​
1362​	604​	2034​	2901​	2268​	2979​	552​	550​	1454​	331​
21​	22​	23​	24​	25​	26​	27​	28​	29​	30​
187​	772​	201​	2438​	2786​	1961​	1392​	2883​	2117​	2050​
30​	32​	33​	34​	35​	36​	37​	38​	39​	40​
2443​	708​	1122​	691​	2976​	580​	2884​	2949​	1877​	2083​

In the example above, the numbers 1 thru 40 identify the order of the songs to be played. the numbers directly below them are the Row numbers of the worksheet "50-69" containing the 3000 songs. Thus, the first song to be played would be in Row 2611 with the song title in Column A. To make the whole process easier, I would like to create another set of numbers 1 thru 40 in a descending Column on the same worksheet with the order of 1 thru 40 in Column A and then fill column B with the actual song title from worksheet "50-69" as identified by the random number. I don't know how to search for a Row number in a formula and that is my problem. Any help will be appreciated.
Thank you,
Dan Wilson...

 

[Jeffrey Mahoney]

@Peter_SSs That sticks in my head when I'm making formulas to last, but it's so easy to forget when I'm in a hurry.