I'm trying to auto populate full rows of information when I select a certain location. On my main packing list, I have locations set up. If I select a city, it pulls the data from sheet 2 and plugs in the city's address, contact and phone number. I want it to also populate the packing information. This will include information from sheet 3. It will need to pull each person and their items they have ordered, over to the packing list. I have used the vlookup function and this will pull the first row of information but I can't figure out how to make it to pull any more. For instance, my first row equation looks like this: =VLOOKUP(H7,Locations2!A1:F7,2,TRUE). This will pull the name of the first person that matches the city on my packing list. But I can't get it to find all the people for this city. I have sample data in this worksheet that I uploaded.