I need a formula that results in the names found in the same row that has a checkbox checked
I have a form I am using for customers to order business cards based on a list of names (column A) on a separate sheet. I'm using check boxes for the customer to identify which names need to be ordered for printing. Right now I have a column that returns the value TRUE if the checkbox is checked, but I would be much happier if there was a formula that results in a list of names (found in column A) orthe row number the names are found whose row has been checked?
I know that I could create a column and use letters or numbers to then index, but this option isn't ideal because the list will constantly be changing (adding names and subtracting names). Therefore, using the actual names, or the row numbers in the results would be ideal because I won't have to keep track of the order of numbers/letters in a separate column.