Lookup Values on a large spreadsheet

Hi

I have a large spreadsheet that identifies stock trading opportunities. There are about 50,000 rows worth of data.

Once I determine where the opportunities are I need to get data from that particular row. This is how I get the data:

Step 1 (formula in cell S2)

If(R2>0, true,false) finding the good trades

Step 2 (formula in cell T2)

If (S2=true,round(s1+1,0),s1+.00000001) numbering the good trading opportunities

Step 3 (on same page but in columns out of range - way to the right of the regular populated data)

In cells BB2-BB11 the numbers 1-10

So in cell BB2 populate 1, BB3 populate 2 etc

In cell BC2

Index(row number,match(BB2,S:S,0))

This will give me the row number for the first trading opportunity

I will do this for the first 10 trading opportunities (finding the row numbers)

step 4
Once I have done this I will use the indirect function to find the data I need in each row(for example: symbol, price etc)

So in cell BD2

Indirect("C"&BC2)

Column C has the stock symbols and this formula will give me the stock symbol for the first opportunity

Similarly in cell BE2

Indirect("F"&BC2)

Column F has the stock prices and this formula will give me the stock price for the first opportunity


Etc etc


The question I have is this Method an efficient way to get data in a large spreadsheet (excel 2010) or would you recommend any different formulas/methods to get the data I require


Thanks