How to Find the Last or First Value in a Range Greater Than X in Excel
XLOOKUP Only Returns First Value | XLOOKUP Return all Matches Vertically Or All Matches in One Cell
Excel の「より大きい場合」と「より小さい場合」の計算式
INDEXMATCHとXLOOKUPの代わりにDGET関数を試してみましょう
IF Function with 4 Criteria in Excel | IF Formula with many Conditions