Forum Discussion
How to pull values from a different sheet based on a checkbox
I have a list of clients and their contact information on one sheet, and an invoice template on the other. I want to pull the clients' names and email addresses into a specific field on my invoice te...
never version of excel have check box feature Insert > Checkbox, you can use the same to insert in you template, when the value is tick you can do xlookup
If this resolves your query don't forget Mark as Solution.