How return in tab Base column E, name in tab Streets column F
in tab Base has Column C and Column D (two criteria), but this value in column D is range of value.
I insert result in column F (i need result in column E equals column F)
In cell E2:
=IFERROR(INDEX(Streets!$F$2:$F$26,SUMPRODUCT(MAX((Streets!$B$2:$B$26=$C2)*(Streets!$C$2:$C$26<=$D2)*(Streets!$D$2:$D$26>=$D2)*(ROW(Streets!$A$2:$A$26))))-1),"")
Copy down
or see attached File
I had to make a few small changes on the sheet worksheet highlighted in Yellow