Range with If/Then Options

[CgG]

New to using a forum, excited to see what I learn. Trying to build a formula based off of what I think is a range with an if then function. Any ideas on how to convert this concept into a working formula?

"If B11 is equal to or between S13 & T13(-1) then cell B12 equals S21 if not blank if blank B12 equals Y24, If B11 is equal to or between T13 & U13(-1) then cell B12 equals T21 if not blank if blank B12 equals Z24, If B11 is equal to or between U13 & V13(-1) then cell B12 equals U21 if not blank if blank B12 equals AA24, If B11 is equal to or greater then V13 then cell B12 equals V21 if not blank if blank B12 equals AB24."

If it helps B11 is a Date, S13/T13 is a Date Range and S21 & Y24 is Pricing....and so on.

thanks

 

[fjns]

Hi, try this formula for B12
=LET(i,MATCH(B$11,$S$13:$V$13,1),r,INDEX($S$21:$V$21,i),IFERROR(IF(r="",INDEX($Y$24:$AB$24,i),r),""))

CgG_ExcelQuestion.xlsx