Multiple IF(AND) References
Hi All,
This might be a simple one but cannot seem to figure out where I'm going wrong. See image below.
So, if my AREA CONCAT column has VALUE 1 in it then I need it to cross reference the first table (bottom right) and run an IF(AND) formula to realize what time slot it's between.
If it's VALUE 2 then it needs to reference the table 2 (bottom right). And there are another 7 more tables like this with 7 different values.
The formula you can see is only for the two tables so far. Is there an easier way to get to this result? Any help on this would help as this formula works for the VALUE 1 but cannot seem to get it working for VALUE 2. I'm wondering if there is a way to infuse an OR function to get to my desired result?
Thanks in advance.
Answers
-
Are you able to create a copy of the sheet and replace the sensitive data with mock data? There should be a way using the INDEX function as the base of the formula but it is hard to tell with so much of your data blocked out.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives