Retrieving data from table

G'day all,

I have a fairly simple matrix table that im needing help in which way to retrieve the information correctly.
Starting in row 10...
My Column A has length that i want to return
My Column B has a minimum value that i need A2 to be larger than, say 20
My Column C has a maximum value that i need A2 to be smaller than.
My Columns C & D, E & F, G & H and so on then have different sizes also available... but thats for me to work out later.


Is the best way to achieve this with a series of If statements as Vlookup only returns values to the right, and i want the value on the left, or what is my best way of tackling this problem.

I can attach a sheet that i started if the above makes no sense but my formula is useless so far...

Thanks in advance.
Dooners.