I would like to write an Excel formula that looks at 3 columns and grabs value of the 1st column based on if the search value is in columns 2 or columns 3.

1st Column 2nd Column 3rd Column
a      1              5
b      6              10
c      11             15  

Search Value 1: 13           Result: c
Search Value 2: 6            Result: b

CodePudding user response：

Try below formula-

=INDEX($A$1:$A$3,MAX(($B$1:$B$3<=B6)*($C$1:$C$3>=B6)*(ROW($A$1:$A$3))))