INDEX / MATCH
 

I am trying to use the above fuctions to match a price from an price /
weight matrix, where the weights are between a lower and upper value e.g 60
gms to 99 gms = $0.42, 100 gms to 149 gms = $0.60. The functions work when
the input weight EXACTLY matches weights of say 60 or 99 or 100 or 149 BUT
will not work where the input weight is between the lower and upper values
e.g 77 gms.
Using 77 gms as an example, I would like this to return $0.42 and if 125 gms
was input, for this to return a value of $0.60.
Any help would be greatly appreciated

The function that can help you is VLOOKUP(). You can set up a table that
will allow you to look up gram weights in ranges. Check out Excel help on
this function
--
Gary''s Student


"cecilmac" wrote:

I am trying to use the above fuctions to match a price from an price /
weight matrix, where the weights are between a lower and upper value e.g 60
gms to 99 gms = $0.42, 100 gms to 149 gms = $0.60. The functions work when
the input weight EXACTLY matches weights of say 60 or 99 or 100 or 149 BUT
will not work where the input weight is between the lower and upper values
e.g 77 gms.
Using 77 gms as an example, I would like this to return $0.42 and if 125 gms
was input, for this to return a value of $0.60.
Any help would be greatly appreciated