What I am looking for is a way to locate supplies. I have been told that a
VLOOKUP would work but I cannot seem to come up with the proper syntax. What
I am looking for is to have a dialog box that I would enter the STORE DESC
and have it list all of the items that come under that column with the ROW,
SELF, BRAND DESC.



Row Shelf Store Desc Supplier Desc Brand Dec Cost Lead/Days
A 3 Cleaner CLR425 Ultra Hand Cleaner 1.12 3
D 5 Cleaner CLR425 Ultra Hand Cleaner 1.12 3
V 4 Cleaner CLR425 Ultra Hand Cleaner 1.23 3
A 4 Bags HB564 Rich Paper Bags 0.23 2
G 8 Bags HB564 Rich Paper Bags 0.23 2
V 9 Bags HB564 Rich Paper Bags 0.23 2
D 6 Rubber Bands RB897 Secure Rubber Bands 0.1 2
G 5 Rubber Bands RB897 Secure Rubber Bands 0.1 2
S 3 Rubber Bands RB897 Secure Rubber Bands 0.1 2
S 6 Rubber Bands RB897 Secure Rubber Bands 0.1 2
Thanks in advance for the help.