Multiple Logic

[nikhilshelkeoutlook]

I needed the formula for multiple lookup value and multiple lookup array to get the correct answer

And search value is between value

[#2]

@nikhilshelkeoutlook 

To get the correct answer, kindly look at the multiple reminders here:

https://techcommunity.microsoft.com/t5/excel/welcome-to-your-excel-discussion-space/m-p/2204395