ReignEternal
New Member
- Joined
- Apr 11, 2021
- Messages
- 41
- Office Version
- 365
- Platform
- Windows
Hello, please forgive my ignorance with this one. I have a situation where I have multiple tables (lets say Table 1 and Table 2 for this scenario) where I need table 2 to act like a clone of table 1. To go deeper, Table 2 must match down to the color and text as in Table 1. All I know is that I can obtain the text by using the following: =INDEX(Table1,MATCH($AP19,Table1[tblRow'#],0),MATCH(A$18,Table1[#Headers],0)), inserting that formula into all cells in the 2nd row then copy down all cells to the following rows. The only issue is this is only giving me the text, not the colors. Any thoughts?
Here is my dropbox link to my file. (i haven't figured out how to use the mini-sheet button yet.
Here is my dropbox link to my file. (i haven't figured out how to use the mini-sheet button yet.