Data below

%3CLINGO-SUB%20id%3D%22lingo-sub-2508851%22%20slang%3D%22en-US%22%3EData%20below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2508851%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20a%20file%20with%20two%20tabs%20and%20I%20would%20like%20to%20copy%20and%20paste%20the%20formulas%20from%20A2%20to%20A3%20the%20problem%20is%20that%20the%20new%20value%20for%20A3%20is%20in%20tab%20Scan%20row%206%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2508851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2508902%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2508902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1093495%22%20target%3D%22_blank%22%3E%40FJMSalgueiro%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20A2%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCLEAN(TRIM(INDEX(Scan!%24A%3A%24A%2C5*ROW()%2BCOLUMN()-5)))%26amp%3B%22%22%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EFill%20down%2C%20then%20to%20the%20right%2C%20or%20vice%20versa.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Have a file with two tabs and I would like to copy and paste the formulas from A2 to A3 the problem is that the new value for A3 is in tab Scan row 6 

1 Reply

@FJMSalgueiro 

In A2:

=CLEAN(TRIM(INDEX(Scan!$A:$A,5*ROW()+COLUMN()-5)))&""

Fill down, then to the right, or vice versa.