LOOKUP FUNCTION STRING HELP. THANKS!

[Dan88]

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:

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.

 

[Fluff]

How about
=IF(BP2<30,LOOKUP(BO2,{0,30,60},{0.95,0.85,0.75}),LOOKUP(BP2,{30,60,120},{0.35,0.3,0.25}))

 

[Dan88]

Hey Fluff, once again you came through for me. Can't thank you enough. Much Much appreciated. You again saved me hours of stringing this together.

Stay well and thanks once again.

 

[Fluff]

You're welcome & thanks for the feedback.