Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If you have two values that equals a certain value, now let says the
value that you have falls in between these two values, how do you get excel to reconize this and return the correct value? For instance: 0 to 15,000 = 0 15,000 to 30,000 = 1 30,000 to 50,000 = 2 My table I have layed out with each value assigned to separate cells. Is this the correct way to lay this table out? In addition, In order to see if I could get the result I need I did a VLOOKUP and the formula returned a #N/A error. What am I doing wrong? Appreciate some help, Thanks Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with V Lookup | Excel Discussion (Misc queries) | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
How do I lookup numbers with a MIN and MAX? | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions |