Hello All. Hope the EXCEL community is doing well.
I have a quick question on this lookup formula if anyone can give me some guidance.
I am re-purposing the formula the forum assisted me back in OCT but need it to do 1 thing.
Currently i am using this:
I have a quick question on this lookup formula if anyone can give me some guidance.
I am re-purposing the formula the forum assisted me back in OCT but need it to do 1 thing.
Currently i am using this:
LOOKUP(BO2,{0,30,60},{0.95,0.85,0.75}) I also need to combine or string this to lookup value in BP2 such that if BP2: 0 - 30 keep above formula 30 - 60 ignore the above and use .35 60 - 120 value should be .30 120+ value should be .25 I tried to use string two lookups but its not working. Thanks in advance for any guidance. |