I have a SharePoint list (Service List) and an excel document (all registered customers) in the same SharePoint 2010.
The Customer list excel document has customer no, location, address, phone number
The service list has customer no, location, address, phone number, plus additional fields related to the service list.
The functionality needed is, when a new service is to be added the user types in the Customer no and the list should automatically populate the rest of the field values ( location, address, phone number) by looking into the row in the excel document.
Customer excel document:
Service List:
Functionality Needed is: When the user types the Customer No: example 109, the form should get automatically populated with
