Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Use the INDIRECT function

=INDIRECT(CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1)))