Function Range Lookup
 

Someone was kind enough to answer me BUT, the notifacation link did not open
and I could not find the response. PLEASE be so kind and reply again. Thanks

I need help!!! UGH!!!!

Example: 2 cells, one titled LEFT & one RIGHT. LEFT has a value in it of
2500 while RIGHT has 3500. They would look up in a chart that looks like this;

LEFT RIGHT $
250 250 40
500 500 100
1000 1000 200
2000 2000 400
3000 3000 600
4000 4000 800
5000 5000 1000

The LEFT 2500 would fall on the leftside between 2000 & 3000 while the RIGHt
3500 would fall between 3000 & 4000 on the rightside. The search would return
the level above the lowest value which in this case would be the 2000 row and
would be $400

I hope that this made sense and thank you for your assistance.
--
Thanks much
Robert

Function Range Lookup
 

http://groups.google.com/group/micro...c5b2c35bf48?q=

--
Gary''s Student - gsnu200828


"robert" wrote:

Someone was kind enough to answer me BUT, the notifacation link did not open
and I could not find the response. PLEASE be so kind and reply again. Thanks

I need help!!! UGH!!!!

Example: 2 cells, one titled LEFT & one RIGHT. LEFT has a value in it of
2500 while RIGHT has 3500. They would look up in a chart that looks like this;

LEFT RIGHT $
250 250 40
500 500 100
1000 1000 200
2000 2000 400
3000 3000 600
4000 4000 800
5000 5000 1000

The LEFT 2500 would fall on the leftside between 2000 & 3000 while the RIGHt
3500 would fall between 3000 & 4000 on the rightside. The search would return
the level above the lowest value which in this case would be the 2000 row and
would be $400

I hope that this made sense and thank you for your assistance.
--
Thanks much
Robert

Function Range Lookup
 

**Maybe** this...

A2 = Left = 2500
B2 = Right = 3500

Your table is in the range A10:C16

Assuming "Left" and "Right" will *always* be within the boundaries of your
table values.

=INDEX(C10:C16,MIN(MATCH(A2,A10:A16),MATCH(B2,B10: B16)))

--
Biff
Microsoft Excel MVP


"robert" wrote in message
...
Someone was kind enough to answer me BUT, the notifacation link did not
open
and I could not find the response. PLEASE be so kind and reply again.
Thanks

I need help!!! UGH!!!!

Example: 2 cells, one titled LEFT & one RIGHT. LEFT has a value in it of
2500 while RIGHT has 3500. They would look up in a chart that looks like
this;

LEFT RIGHT $
250 250 40
500 500 100
1000 1000 200
2000 2000 400
3000 3000 600
4000 4000 800
5000 5000 1000

The LEFT 2500 would fall on the leftside between 2000 & 3000 while the
RIGHt
3500 would fall between 3000 & 4000 on the rightside. The search would
return
the level above the lowest value which in this case would be the 2000 row
and
would be $400

I hope that this made sense and thank you for your assistance.
--
Thanks much
Robert