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
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies