Lookup Excel Value in SharePoint List and Update Excel Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2779012%22%20slang%3D%22en-US%22%3ELookup%20Excel%20Value%20in%20SharePoint%20List%20and%20Update%20Excel%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2779012%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20with%20the%20following%20fields%3B%26nbsp%3B%3CEM%3EEmployeeID%2C%20Surname%20and%20First%20Name.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20have%20an%20empty%20table%20with%20the%20following%20columns%20on%20Excel%20Desktop%3B%26nbsp%3B%3CEM%3EEmployeeID%26nbsp%3B%3C%2FEM%3E%3CEM%3ESurname%3C%2FEM%3E%20and%26nbsp%3B%3CEM%3EFirst%20Name.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20enter%20a%20value%20in%20the%26nbsp%3B%3CEM%3EEmployee%20ID%26nbsp%3B%3C%2FEM%3Ecolumn%2C%20can%20I%20get%20the%20steps%20below%20to%20play%20out%3F%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20The%20Employee%20ID%20value%20gets%20looked%20up%20in%20the%20SharePoint%20List%20from%20the%26nbsp%3B%3CEM%3EEmployee%20ID%3C%2FEM%3E%26nbsp%3Bfield%2C%20then%20gets%20the%20employee's%20corresponding%26nbsp%3B%3CEM%3ESurname%3C%2FEM%3E%26nbsp%3Band%20First%3CEM%3E%20Name.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Takes%20the%20corresponding%20values%20from%20the%20SharePoint%20List%20and%20updates%20the%20%3CEM%3ESurname%3C%2FEM%3E%20and%26nbsp%3B%3CEM%3EFirst%20Name%26nbsp%3B%3C%2FEM%3Ecolumns%20in%20the%20Excel%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2779012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

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; EmployeeID Surname and First Name.

 

When I enter a value in the Employee ID column, can I get the steps below to play out?        

 

1. The Employee ID value gets looked up in the SharePoint List from the Employee ID field, then gets the employee's corresponding Surname and First Name.

 

2. Takes the corresponding values from the SharePoint List and updates the Surname and First Name columns in the Excel table.

 

Many thanks.

 

 

 

 

0 Replies