I have been scratching my head trying to work this out, I would be grateful if you can help. The formula below offsets 3 places when it finds “Earnings for Period”. However if that cell is enter or zero “0”, I want it to offset 4 places. Any suggestions?
=OFFSET(INDEX($C$2:$C$100,MATCH("Earnings for Period",$C$2:$C$100,0),1),0,3)
Aucun commentaire:
Enregistrer un commentaire