Nov 29 2022 05:57 AM - edited Nov 29 2022 06:36 AM
Hi,
I don't really know how to explain this however I will try my best here.
I have an Excel spreadsheet of all of our retail stores including store number, address, phone, IP address etc etc. We call this the Stores Master List.
We also have an Excel spreadsheet that has VLOOKUP commands to populate a table when we select x number of stores that have not transferred data overnight. We call this our Polling Report.
=VLOOKUP([@[Store Number]],'https://xxx.sharepoint.com/sites/ASWITSS/Shared Documents/General/[Stores Master List.xlsx]STORE MASTER SHEET'!$A:$C,3,FALSE)
As you can see the Store Name is populated by the VLOOKUP from the Stores Master List.xlsx
I have now uploaded this Stores Master List.xlsx to a Microsoft List so we can make it easier to share but also update as and when we have new stores added or remove closed stores.
What I can't seem to work out is how to use a similar VLOOKUP command to populate the Store Name field in our Polling Report spreadsheet that needs to pull the data from the Microsoft List instead of the Stores Master List spreadsheet.
Any help would be amazing
Dec 14 2022 02:42 AM