Hi there,
I want to use the number part of a cell reference of one worksheet in to index some figures onto another worksheet.
I have tried =INPUT!$A(ROW(INPUT!$A5+8) but its returning an 'name?' error.
Please see the attached for an example, any other ideas suggestions to do it are welcome.
Essentially I would have to manually input into either worksheet but inputting into INPUT would be quicker than into HEADCOUNT.
Thanks in advance,
PC
Bookmarks