Thank you for writing back. Yes, the formula needed for your requirement is vlookup so that you can pull out the data from sheet 1 and display them on the printable sheet.
I believe the final file I gave you shows how it works.
In the vlookup formula, all you need to change is the column that you want to pull out. For instance:
That formula pulls out Group Name data since it calls for column 2 (the 2 before FALSE).
I hope that helped.
Please remember to rate my service positively (3-5 stars/faces)
once you have all the information you need. Tips
are always highly appreciated!
If you have any other questions, please ask me or reply to me
– I’ll be happy to respond.