Retrieving data from table

[dooners99]

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.

[sglife]

Please give a sample with the result you want

[dooners99]

Thanks,

I have attached below,
As i said the formula in B4 is way off what it needs to be...

Regards,
Dooners.

[rylo]

Hi

Can you explain your logic / calculations to work out why your result should be 50? Your example doesn't seem to match the descriptions you have given in the original post - or if they do, I can't follow...


rylo

[dooners99]

Hi Rylo,

The logic behind this is as follows,
I select the size ( in this case 16 )
Then enter my "grip" being 20.
The result should be the minimum length where the grip "20" is larger than the value in the 16 min column, but small than the 16 max column. This then puts the length at 50 ( column A )
The length is actually refering to the coulmn not refering to the row, 16 or 20 across the top.

Sorry for confusion.

[rylo]

Hi

Try this array entered (ctrl, shift, enter).

Please Login or Register  to view this content.

Or if you want to make it dependent on the value in B2, then try

Please Login or Register  to view this content.

rylo

[dooners99]

Thanks for the help Rylo, exactly the start i needed!