Lookup Excel Value in SharePoint List and Update Excel Table
Hello, I have a SharePoint list with the following fields;EmployeeID, Surname and First Name. I also have an empty table with the following columns on Excel Desktop;EmployeeIDSurname andFirst Name. When I enter a value in theEmployee IDcolumn, can I get the steps below to play out? 1. The Employee ID value gets looked up in the SharePoint List from theEmployee IDfield, then gets the employee's correspondingSurnameand First Name. 2. Takes the corresponding values from the SharePoint List and updates the Surname andFirst Namecolumns in the Excel table. Many thanks.