If Formula

Hello. I have a column name Section and a column name District. I have the Section numbers in the column and I need it to calculate the District number.

So if my Section Column has any of these Sections 001, 002, 003, 004, 011, 013, 015, 035, 031, 032, 033, or 034, I need it to mark the District column as District 1. And if my Section Column has any of these Sections 005, 006, 007, 008, 014, 019, 040, 041, 042, 043, 044, 045, or 046, I need it to mark the District column as District 2. And if my Section Column has any of these Sections 009, 010, 012, 016, 017, 181, 182, or 183, I need it to mark the District column as District 3.

Another possible formula would use conditional formatting. Say I have all the rows for Sections 005, 006, 007, 008, 014, 019, 040, 041, 042, 043, 044, 045, or 046, yellow, Can I set up a formula to put District 1 in the District column based on the row color?

Thanks in advance

Find more posts tagged with

Accepted answers

Andrée Starå

Hi @Chevon Brownell

I hope you're well and safe!

I'd probably recommend using a table with the options combined with a VLOOKUP or IDEX/MATCH formula structure.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Bassam Khalil

Hi @Chevon Brownell

Hope you are fine, hope you are fine to try to use the following sample formula and configure it by adding all your criteria. and convert it to column formula

=IF(OR(Section@row = "001", Section@row = "002"), "District 1", IF(OR(Section@row = "003", Section@row = "004"), "District 2", IF(OR(Section@row = "009", Section@row = "010"), "District 3", "")))

Andrée Starå

Hi @Chevon Brownell

I hope you're well and safe!

I'd probably recommend using a table with the options combined with a VLOOKUP or IDEX/MATCH formula structure.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Chevon Brownell

@Andrée Starå andree@workbold.com So the first picture is my district list and the second picture shows the sheet I need to populate. Can you help with a formula? I have tried on my own and I tried Bassam's suggestion. I keep getting unparseable or incorrect argument, So I am obviously doing something wrong.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.