I have a separate list with information that I would like to fill another list but I am unsure how to do this or where to learn how to do this. I have list echo that has a column A titled Name and column B is titled client with other columns that have information such as contact details. However, in list bravo I would like to fill in a column with client and the Name from the other list will automatically get filled in. Is this scenario possible and where can I learn how to do this?

I have a separate list with information that I would like to fill another list but I am unsure how to do this or where to learn how to do this. I have list echo that has a column A titled Name and column B is titled client with other columns that have information such as contact details. However, in list bravo I would like to fill in a column with client and the Name from the other list will automatically get filled in. Is this scenario possible and where can I learn how to do this?

Echo (Contact Info which would be one list)

Name     Client        Address      URL         Email
John Doe Alpha Client  1234 Blvd rd www.url.com [email protected]

Bravo (order in process which would be another list)

Name     Client        Item      Quantity Shipping Order Processed
John Doe Alpha Client  Gold Leaf 10       Yes      Yes

Info would be pulled from List Echo and will automatically fill List Bravo when you enter Alpha Client in Bravo it will fill Bravo's name with John Doe. I would like an end result to occur when the drop down of Bravo's Order Processed is selected to yes it will move everything to a new List of completed transactions and removing everything from the List Bravo.

I have found where I can create a List, Right Click > Add Column > Select Lookup but it wont auto fill from one column selection. Does the Lookup have to be first in the List?