using arrays to sort data?

  • Thread starter Thread starter Phil
  • Start date Start date
P

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?!!!
 
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)
 
Back
Top