Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with lookup formula
i am trying to enter a formula that will return a specific number for
a range of numbers. Example: i know that if i have between a range of items, that i need to return a specific number for that formula. if the number is between 0 and 53 it needs to return a 4, if the number is between 54 and 65 it needs to return a 5 and so on. i tried using lookup and choose, but i get errors in the formula....this is the formula i used. =LOOKUP(E45,{53,65,77,89,101,113,125,137,149,161,1 73}, {4,5,6,7,8,9,10,11}) E45 is the cell with the calculated value that now needs to be checked to return the number i am looking for. in this case, E45 has a 35 in it, so the formula should return a 4, but instead i get a #N/A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup formula | Excel Discussion (Misc queries) | |||
row lookup formula | Excel Worksheet Functions | |||
lookup formula? | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
If the lookup-value is a formula | Excel Worksheet Functions |