<div>
<div class="content wysiwyg-content">
A SharePoint export &nbsp;of a simple list to Excel from O365 is missing the autogenerated ID (number) column. &nbsp;I need this column to complete the rest of the project. &nbsp;I see that I can create a lookup field to copy that field but don't see how to make it copy the field automatically. &nbsp;New items in the list show 'required field' and then the data has to be selected from a drop down. &nbsp;I need it to fill upon creating the item. Do I need another list for the lookup? Then how do I make it increment normally?
</div>
</div>


A SharePoint export  of a simple list to Excel from O365 is missing the autogenerated ID (number) column.  I need this column to complete the rest of the project.  I see that I can create a lookup field to copy that field but don't see how to make it copy the field automatically.  New items in the list show 'required field' and then the data has to be selected from a drop down.  I need it to fill upon creating the item. Do I need another list for the lookup? Then how do I make it increment normally?

How to make a lookup field for the ID field in Sharepoint list automaticlly fill the lookup field.

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

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