excelsior00
New Member
- Joined
- Apr 4, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to consolidate a table of somewhat binary information. I assume I need to do a mix of indexing, matching, and if functions, but getting a little bit lost. Here is what I'm trying to accomplish (blue is what I have, orange is what I'm trying to make):
As you can see, anytime a 1 appears, I'd like to return the associated color--assigning it to the proper animal and offspring--somewhat consolidating the table.
Any help would be much appreciated!
I am trying to consolidate a table of somewhat binary information. I assume I need to do a mix of indexing, matching, and if functions, but getting a little bit lost. Here is what I'm trying to accomplish (blue is what I have, orange is what I'm trying to make):
As you can see, anytime a 1 appears, I'd like to return the associated color--assigning it to the proper animal and offspring--somewhat consolidating the table.
Any help would be much appreciated!