I need a formula that will lookup a value, if found return the answer, if not found look up the next value, if found return the answer, if not found look up the next value and return the answer.
look up data
100 200 300
table
1001 56
1002 59
200 60
450 58
Formula would check 100 first, not find it and then check to 200 find it and return the value 60
look up data
100 200 300
table
1001 56
1002 59
200 60
450 58
Formula would check 100 first, not find it and then check to 200 find it and return the value 60