extracting unknown data from sheet 1 to sheet 2

Originally Posted by wurugu

I need to extract numbers on the first sheet and list them in sheet 2. The numbers are in the middle of the first list starting at 300.51 thru 500.99. I need to use the numbers listed in sheet 2 to lookup data in sheet 1.

This point is very confusing. You said you need to extract numbers from sheet 1 - on what basis?

Then again, these numbers need to be looked up in sheet 1? This can be done provided we understand on what basis the numbers will be extracted to sheet 2.