Hey all! I'm having trouble with a LOOKUP function. I have a range of numbers (Percentages in 1 column, Numbers in the adjacent right column) that go from 677 to -677. I am wanting to match the Percentage and return the Number in the column next to it (which is what LOOKUP is supposed to do). The problem I'm having is the formula is returning the lowest negative number (-677) even if the result should be a positive number. The only thing I can assume is that LOOKUP doesn't like negative numbers and will default to the lowest value in the range. What is the solution???
=IF(ISERROR(LOOKUP(V131,S133:T231,T133:T231)),"",LOOKUP(V131,S133:T231,T133:T231))
"S" column starts with .99 and goes down to .01
"T" column starts with 677 and decreases by 7 till 0, then continues with -7,-14, -21, etc. [50% (S column) = "0" (T column)]
Thanks for the help!!
=IF(ISERROR(LOOKUP(V131,S133:T231,T133:T231)),"",LOOKUP(V131,S133:T231,T133:T231))
"S" column starts with .99 and goes down to .01
"T" column starts with 677 and decreases by 7 till 0, then continues with -7,-14, -21, etc. [50% (S column) = "0" (T column)]
Thanks for the help!!