Hello, I have attached a spreadsheet which includes a formula which has previously worked but, for some reason, has stopped.
In worksheet ;invoice publishing' I need to return a value in A17 depending on the code in L10. I need it to look at the information in PRINT Orders worksheet.
I have all the formulas entered, it looks like this
=IF(ROWS($A$72:$A72)>$A$15,"",INDEX('PRINT orders'!D6:D95,MATCH(ROWS($A$72:$A72),'PRINT orders'!AK6:AK44,0)))
If anybody could take a look at the attached and give me an indication as to why this has stopped working that would be much appreciated!