I have a spreadsheet consisting of two worksheets. The first is a complete roster of names. The second is a list of those scheduled for various positions for a given month. I would like to create a third sheet with a list of those who are not scheduled. I have created a column on the complete list using VLOOKUP and have identified those who are not scheduled. How can I pull only those with #N/A in column with the VLOOKUP formula (those who are not scheduled) to a third worksheet?
Thanks in advance.