In Sharepoint, I want to be able to look at the value in column A (a Name) use that value in another list, pull a value from that other list's row and return in to the first Sheet's Column B.
The Excel File (in SharePoint) has a Name and Zip column.
The List has the same two columns.
I want to be able to look up the User's zip form the List, but matching the names, avoiding the redundancy of putting a zip in mulitple places.
I am not sure if this is even possible?