How can I convert a row in one sheet into a column in another sheet based on a checkbox?
I am trying to convert the information in my resource request sheet into a customer data sheet when a box is checked in the resource request sheet. When a request is entered it will flow into the database for resource request. I would like to give my client the option of checking the box of the customer who's details they want to look at and have that information flow into the customer data sheet when the box is checked. They can then print that sheet for that customer, uncheck their box and select another and print the sheet again with a new customer's data filled in. I have tried VLOOKUP, INDEX/MATCH and a nested IF function and I have yet to find a solution that works. I'm including a screenshot of both sheets. I am attempting to keep this system as close to what they are replacing as possible. I have also tried a report from the request sheet, but cannot link either a formula to the report or metrics on a dashboard to the report. And I can't link metrics based on a checkbox.... racking my brain to try and find a solution that keeps them functioning as close to their current system as possible.
Help Article Resources
Check out the Formula Handbook template!