User Profile

jalverson

Copper Contributor

Joined May 19, 2020

4 Posts

View All Badges

User Widgets

Recent Discussions

Re: Complex autofill formula
Austris Bahanovskis Thanks for the answer. I wasn't considering the if(or(>= would always return the the cell I was referring to in every cell. It makes sense now. Appreciate the input. Thanks!
May 21, 2020 Place Excel
1.6KViews
0likes
0Comments
Re: Complex autofill formula
Riny_van_Eekelen This worked great. It is exactly what I was trying to achieve in a complex manner. I haven't used VLOOKUP in about 15 years and forgot about it. Thanks for the help!
May 21, 2020 Place Excel
1.6KViews
0likes
0Comments
Re: Complex autofill formula
Austris Bahanovskis Thanks, I have uploaded a copy of the Workbook that is in question. Again, in swedish, so I am not sure if you can read or open it. However, I have placed notes with Yellow highlighting on the column in question.
May 20, 2020 Place Excel
1.6KViews
0likes
2Comments
Complex autofill formula
I am creating a column of cells (column e) on a data sheet that I want to auto-fill with the contents of a different cell from datasheet named Blad 1 (column A) if the contents in column F fall within a range of numbers within the Åtgärderskoder datasheet's column B and return nothing if it does not match that criteria. I have completed the initial cell formula which seems to work and returned the result I expected, but when I drag down to auto format, the autofill places a combination of different results (several cells from the Blad 1 datasheet into the same cell). For example: (is in Swedish (om=if, och=and, eller=or, ;=,) I apologize for the Swedish formula, but I do not write swedish well and needed help on an english forum.).... =OM(ELLER(F2>=Åtgärdskoder!$B$4;F2<=Åtgärdskoder!$B$25;F2>=Åtgärdskoder!$B$30;F2<=Åtgärdskoder!$B$46);Blad1!$A$3;"")&OM(OCH(F2>=Åtgärdskoder!$B$26;F2<=Åtgärdskoder!$B$29);Blad1!$A$4;"")&OM(OCH(F2>=Åtgärdskoder!$C$47;F2<=Åtgärdskoder!$B$216);Blad1!$A$7;"")&OM(OCH(F2>=Åtgärdskoder!$B$217;F2<=Åtgärdskoder!$B$255);Blad1!$A$8;"")&OM(OCH(Plan!F2>=Åtgärdskoder!$B$256;Plan!F2<=Åtgärdskoder!$B$277);Blad1!$A$8;"")&OM(OCH(F2>=Åtgärdskoder!$B$278;F2<=Åtgärdskoder!$B$332);Blad1!$A$6;"")&OM(OCH(F2>=Åtgärdskoder!$B$333;F2<=Åtgärdskoder!$B$337);Blad1!$A$15;"")&OM(OCH(F2=Åtgärdskoder!$B$338);Blad1!$A$9;"")&OM(OCH(F2>=Åtgärdskoder!$B$339;F2<=Åtgärdskoder!$B$350);Blad1!$A$11;"")&OM(OCH(F2>=Åtgärdskoder!$B$351;F2<=Åtgärdskoder!$B$355);Blad1!$A$13;"")&OM(OCH(F2>=Åtgärdskoder!$B$356;F2<=Åtgärdskoder!$B$378);Blad1!$A$10;"") Result returns as Code 2 (which is what I expected) However, when I drag down to autoformat the formula, the result vary and will return Code 2 and code 7 or some other number that it matches. How do I rectify this or is there a better formula to utilize multiple contingencies? Any help would be appreciated if it is possible. Thanks! I have loaded a copy of the workbook and the sheet I am configuring is the one named Plan. I have set notes in the cells in Column E so you understand better what is resulting.
May 20, 2020 Place Excel
excel
1.8KViews
0likes
6Comments

Recent Blog Articles

No content to show