Hello everyone. I have a powerapp that uses 2 lists as data sources. List 1 has a parts column and a vendorname column, and is about 500 rows long. List 2 has vendorname, address, contact# columns and is 29 rows long. I want to join these so list 1 pulls the contact info from list 2. The best way for me to explain this is by simulating a VLOOKUP in excel. That would be simple. I have tried using a LOOKUP in List 1, but I need to go back and in the lookup column choose the vendor name, even though it is in the column right next to it. Is there a way to use the existing vendorname column to join them together?