Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Thanks for your answer Mike. I can't put the whole file as it contains personal information. But here are the formulas that generate the error messages. LO 5.2.5.1

The following show correctly in Excel Online, but in LO they generate #ref!. By the way, when opening the file, a dialogue box says 'This file contains links to other files. Should they be updated?'

=INDEX(OFFSET($Input.A:A,,shift),MATCH(F22,$Input.A:A,0)+3,)

=INDEX(OFFSET($Input.A:A,,shift),MATCH(F22,$Input.A:A,0)+4,)

=INDEX(OFFSET($Input.A:A,,shift),MATCH(F26,$Input.A:A,0)+3,)