R
Rod
Hello.
I would like to be able to do the equvivalent of:
look up a number in range MaxTermAvail and if the number is < the left value
then bring back the next col; something like
Vlookup (B2, if B7<the left value(MaxTermAvail), 2, false).
So, if B2=61 then the value returned should be 15, when
MaxTermAvail=
41 35
46 30
61 20
66 15
71 10
Thanks.
I would like to be able to do the equvivalent of:
look up a number in range MaxTermAvail and if the number is < the left value
then bring back the next col; something like
Vlookup (B2, if B7<the left value(MaxTermAvail), 2, false).
So, if B2=61 then the value returned should be 15, when
MaxTermAvail=
41 35
46 30
61 20
66 15
71 10
Thanks.