Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

#ref! showing in .xls file

Editing an .xls file. Numerous cells do not dsiplay normally showing '#ref!' and code such as '=INDEX(OFFSET($Input.A:A,,shift),MATCH(F22,$Input.A:A,0)+3,)' .

I am not conversant in formulas. I was only seeking to add some text to this file. It displays normally in Excel Online

I would appreciate any comments. Thanks.