Support Board
Date/Time: Wed, 29 Oct 2025 20:35:06 +0000
Post From: Excel error & GetCorrespondingMatch multiple criteria selection
| [2018-03-26 01:34:31] |
| Sawtooth - Posts: 4281 |
|
Try this example: In a Formula Column, e.g. P3: =E3<$J$48 In another Formula Column, e.g. Q3, or in a single non-repeating cell: =INDEX(E3:E1002,MATCH(1,P3:P1002,0),1) |