Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Why can I not find the answers to my posts? I get notifacation that a reply
was sent, but can not find it?? If someone is sending, could you send it to my email address: THANKS MUCH 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 -- Thanks much Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function Range Lookup | Excel Worksheet Functions | |||
return range of data from lookup function | Excel Worksheet Functions | |||
return range of data from lookup function | Excel Worksheet Functions | |||
Limiting the range of a lookup function | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |