• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup range of number based criteria

marreco

Member
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)
 

Attachments

  • LookUp_RangeOfValueNumber.xlsx
    15 KB · Views: 0
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
 

Attachments

  • LookUp_RangeOfValueNumber.xlsx
    15.7 KB · Views: 1
Back
Top