Login Page - Create Account

Support Board


Date/Time: Thu, 10 Sep 2026 18:27:38 +0000



Post From: Index and Match on spreadsheet

[2015-01-01 21:48:43]
Sawtooth - Posts: 4351
Here's a workaround, using another Formula Column, e.g. P:
cell P3:
=IF(O3>0,1,0)
then:
=INDEX(O4:O36,MATCH(1,P4:P36,0),1)