Forum Discussion
IF.. I am trying to get information from one sheet to mirror in a second sheet IE IMPUT TO QUOTE
{=IFERROR(INDEX('COST PRICE ESTIMATE SHEET'!A$16:A$872,SMALL(IF('COST PRICE ESTIMATE SHEET'!$J$16:$J$872<>0,ROW('COST PRICE ESTIMATE SHEET'!A$16:A$872)-ROW('COST PRICE ESTIMATE SHEET'!A$16)+1),ROWS('...
That's array formula, did you enter entire formula =IFERROR(...,"") with Ctrl+Shift+Enter ?
Hi Yes how the file works, only if I add a quantity out of the list of 872 lines will it appear in the quote, originally a Pal did this formula and I have been copying / paste for the last 12 months and its worked fine but now its just not picking up?
Sorry, but I didn't catch what exactly doesn't work. Formula itself is correct, it copies values from column A starting from row 16 if only for such rows values in J are not zeros. May you attach the file or at least screenshot which illustrates what doesn't work?
