<div>
Any sample for us to work on?
</div>


<div>
<div class="content wysiwyg-content">
Greetings,<br />
I have a spreadsheet consisting of two worksheets. &nbsp;The first is a complete roster of names. &nbsp;The second is a list of those scheduled for various positions for a given month. &nbsp;I would like to create a third sheet with a list of those who are not scheduled. &nbsp;I have created a column on the complete list using VLOOKUP and have identified those who are not scheduled. &nbsp;How can I pull only those with #N/A in column with the VLOOKUP formula (those who are not scheduled) to a third worksheet?<br />
Thanks in advance.<br />
Marvin
</div>
</div>


Greetings,
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.
Marvin

Create a worksheet with list of rows containing &quot;#N/A.&quot;

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Create a worksheet with list of rows containing &quot;#N/A.&quot;

Create a worksheet with list of rows containing "#N/A."