Condition needed to an existing formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3120562%22%20slang%3D%22en-US%22%3ECondition%20needed%20to%20an%20existing%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3120562%22%20slang%3D%22en-US%22%3E%3CP%3EDears%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20all%20the%20formulas%20working%20but%20I%20need%20a%20condition%20if%20it%20sees%20one%20of%20the%207%20letters%20in%20TAB1%20B%2FE%2FH%20columns%20etc%20to%20write%20the%20exact%20value%20letter%20in%20that%20cell.%20TAB3%20are%20my%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%200%3A00%20%2F%20S8%20%2F%200%3C%2FP%3E%3CP%3EExample%20if%20it%20is%20a%20number%3A%207%3A00%20%2F%208%20%2F%200%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20keep%20the%20formulas%20as%20they%20are%20and%20to%20add%20the%20condition%20and%20to%20be%20able%20to%20drag%20them%20left%20or%20down%20and%20to%20keep%20the%20formatting.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20sum%20up%20in%20excel%20words%20-%20I%20have%203%20rows%20that%20go%20together%20all%20the%20way%20to%20ZZZ1%20for%20example.%20If%20something%20changes%20in%20TAB1%20to%20reflect%20in%20TAB3%20accordingly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20for%20example%20if%20in%20TAB1%20cell%20B2%20sees%20S8%20to%20write%20in%20TAB3%26nbsp%3B%20cell%20B1%20to%20write%20the%20actual%20letter%20it%20finds%20in%20TAB1%20B%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20current%20formula%26nbsp%3B%20in%20A1%20which%20will%20stay%20the%20same%2C%20I%20need%20help%20for%20the%20formula%20in%20B1%20below%20to%20add%20the%20condition.%3C%2FP%3E%3CP%3E%3D'TAB1'!A2%3C%2FP%3E%3CP%3EHere%20is%20the%20current%20formula%20without%20the%20condition%20in%20B1%3A%3C%2FP%3E%3CP%3E%3D'TAB1'!B2%2B%40INDEX('TAB2'!%24A%242%3A%24ZY%242%2C1%2B2*INT((COLUMNS(%24B1%3AB1)-1)%2F3))%3C%2FP%3E%3CP%3EHere%20is%20the%20current%20formula%20without%20the%20condition%20in%20C1%3C%2FP%3E%3CP%3E%3D'TAB1'!C2%2B%40INDEX('TAB2'!%24B%242%3A%24ZY%242%2C1%2B2*INT((COLUMNS(%24B1%3AB1)-1)%2F3))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20see%20where%20can%20I%20attach%20the%20file%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3120562%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Dears,

 

I have already all the formulas working but I need a condition if it sees one of the 7 letters in TAB1 B/E/H columns etc to write the exact value letter in that cell. TAB3 are my results.

 

Example: 0:00 / S8 / 0

Example if it is a number: 7:00 / 8 / 0 

 

I want to keep the formulas as they are and to add the condition and to be able to drag them left or down and to keep the formatting. 

 

To sum up in excel words - I have 3 rows that go together all the way to ZZZ1 for example. If something changes in TAB1 to reflect in TAB3 accordingly.

 

So for example if in TAB1 cell B2 sees S8 to write in TAB3  cell B1 to write the actual letter it finds in TAB1 B column. 

 

Here is the current formula  in A1 which will stay the same, I need help for the formula in B1 below to add the condition.

='TAB1'!A2

Here is the current formula without the condition in B1:

='TAB1'!B2+@INDEX('TAB2'!$A$2:$ZY$2,1+2*INT((COLUMNS($B1:B1)-1)/3))

Here is the current formula without the condition in C1

='TAB1'!C2+@INDEX('TAB2'!$B$2:$ZY$2,1+2*INT((COLUMNS($B1:B1)-1)/3))

 

I didn't see where can I attach the file? 

 

Thank you!

0 Replies