Sharepoint List Vlookup

Hi djreyes,

you can have kind of this effect if you connect two list webparts through dynamic filtering.

1) Create two lists, i.e. Customers and Invoices
2) On the "Invoice" list create a lookup column to the "Customer". Name it "CustomerID"
3) Fill in some values in both lists
4) Create a new page in SharePoint

5) Add two "List" webparts to the page. One for "Cusomters", one for "Invoices"

6) Edit the settings for the "Invoice" Webpart
7) Select "Dynamic filtering" and make these setting


Now you have two list views

If you select a customer in the left list, the invoices list on the right will filter to just the invoices of that customer.

You don't necessary need lookup columns to do so (String and number columns also work) and you can even have more than two list.

Best Regards,
Sven