using arrays to sort data?

[Phil]

What I'm doing is definitely not new, however, I am. I am
looking to create a table that includes certain dimensions
- cell range WS3!A3-23 - and has coinciding prices - cell
range WS3!C3-E23.

Much the same as a pricing sheet would work, I am trying to
have a value inputed in cell WS2!F3, from that value sort
find the value range it falls between with respect to
WS3!A3-23, and then match that with cell WS2!J3 which will
in turn sort through WS3!C3-E23.

So basically the mathematical equation I am looking to do
is this:
(on sheet WS2)
=(F3/9)*J3(or whatever J3 will result in)

Where J3 will be the number of mobilities for product X
depending on size and this will then be calculated against
the size of the product, resulting in the price for
installation.

Everyone follow me? Help?!!!

 

[Frank Kabel]

Hi
not completely sure but try
(assumption: data on sheet WS3 is sorted ascending)
=MATCH('WS2'!$J$3,OFFSET('WS3'!$C$3:$E$3,MATCH('WS2'!$F$3,'WS3'!$A$3:$A
$23,1)-1,0),1)