I have 2 worsheets (sheet 1 & sheet 2).
Column B of sheet 2 (Product Name) needs data from sheet 1.
Data in Sheet 1 is column A=Vendor Name , column B = Product Name.
I need to sort through sheet 1 to create a list in sheet 2 that specifies
product name per vendor (i.e. all the products from Pepsi).

I tried the following formula, but it only works if there is 1 product from
Pepsi.
The formula in B2 is =VLOOKUP(A1,Sheet1!B$2:C$1000,2,FALSE).

What formula should I use to sort through sheet 1 to get all the products
from Pepsi? Thank you in advance.