Support Board
Date/Time: Sun, 19 Jan 2025 09:16:10 +0000
Post From: Excel error & GetCorrespondingMatch multiple criteria selection
| [2018-03-26 01:34:31] |
| Sawtooth - Posts: 4155 |
|
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) |