Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 06:48:41 +0000
Post From: Excel error & GetCorrespondingMatch multiple criteria selection
| [2018-03-26 01:34:31] |
| Sawtooth - Posts: 4000 |
|
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) |