Forum Discussion
Possibly simple solution
Please find the attached with the formulas in place. You only need to enter the table number in column D and the names will be populated in the relevant table automatically as per the entered number.
Also, note that I have added a custom number formatting for all the table headers (green cells) so that they contain only a number but a prefix of Table is added to all of them. e.g. if you look at the cell F1, it contains a number 1 but the cell shows you the text "Table 1" where the "Table" prefix is added through the custom number formatting whereas the actual cell content is only 1.
If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.
= IF( D2=$F$1, B2, "")
In G2 type
= IF( D2=$F$1, C2, "")
Then, drag the formulas down to the other rows.
If you want to have First and Last name in just one cell, type in F2:
= IF( D2=$F$1, B2 & " " & C2, "")
I hope I understood your requirement correctly.
Celia_AlvesThankyou for this 🙂 my only problem is now that it will only put in the first 10 names in the 1 section, how do I adjust the formula to make the names appear under other number sections when entering 6 next to the names or any other numbers? You can see the 6 section in the picture from before. I've tried to adjust the formulas but its not working. Does this make sense?
