Home

having trouble with a formula, it won't add new input to the sub tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-694890%22%20slang%3D%22en-US%22%3Ehaving%20trouble%20with%20a%20formula%2C%20it%20won't%20add%20new%20input%20to%20the%20sub%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694890%22%20slang%3D%22en-US%22%3EI've%20been%20working%20on%20a%20formula%20to%20extract%20data%20from%20the%20master%20sheet%20on%20excel%20to%20sub%20sheets.%20I've%20got%20the%20formula%20to%20work%20but%20when%20I%20enter%20new%20teams%20on%20the%20master%20sheet%2C%20it's%20not%20extracting%20to%20the%20sub%20sheets%20properly.%20it%20creates%20a%20%23number%20error.%20What%20am%20I%20doing%20wrong%3F%20Please%20look%20on%20the%20tyke.novice%20tab%20to%20see%20the%20problem%20i'm%20commenting%20on.%20%3DIF(ROWS(%24A%243%3AA5)%26gt%3B%24J%241%2C%22%22%2CINDEX(%5BYHLRegistation%5DMaster!A%242%3AA%2419%2CSMALL(IF(%5BYHLRegistation%5DMaster!%24B%242%3A%24B15%3D%24C%241%2CROW(%5BYHLRegistation%5DMaster!%24B%242%3A%24B15)-ROW(%5BYHLRegistation%5DMaster!%24B%242)%2B1%2C%22%22)%2CROWS(A%243%3AA5))))%20that%20is%20my%20formula.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-694890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-695076%22%20slang%3D%22en-US%22%3ERe%3A%20having%20trouble%20with%20a%20formula%2C%20it%20won't%20add%20new%20input%20to%20the%20sub%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695076%22%20slang%3D%22en-US%22%3EYou%20are%20obviously%20referring%20to%20an%20external%20workbook.%20Thus%2C%20you%20must%20include%20the%20extension%20name%20in%20the%20workbook%20name%2C%20like%20this%3A%3CBR%20%2F%3E%5BYHLRegistation.xlsx%5D%3CBR%20%2F%3EIf%20possible%2C%20avoid%20external%20references.%20Instead%2C%20refer%20to%20ranges%20in%20the%20same%20workbook%2C%20although%20in%20another%20worksheet.%3C%2FLINGO-BODY%3E
cullenrevel
New Contributor
I've been working on a formula to extract data from the master sheet on excel to sub sheets. I've got the formula to work but when I enter new teams on the master sheet, it's not extracting to the sub sheets properly. it creates a #number error. What am I doing wrong? Please look on the tyke.novice tab to see the problem i'm commenting on. =IF(ROWS($A$3:A5)>$J$1,"",INDEX([YHLRegistation]Master!A$2:A$19,SMALL(IF([YHLRegistation]Master!$B$2:$B15=$C$1,ROW([YHLRegistation]Master!$B$2:$B15)-ROW([YHLRegistation]Master!$B$2)+1,""),ROWS(A$3:A5)))) that is my formula.
1 Reply
You are obviously referring to an external workbook. Thus, you must include the extension name in the workbook name, like this:
[YHLRegistation.xlsx]
If possible, avoid external references. Instead, refer to ranges in the same workbook, although in another worksheet.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies