hi Daniell,

Dave & Excellenator has given you good suggestions to use Autofilter.

And to VLOOKUP you need to have at least one column unique so that
VLOOKUP can work normal. Moreover, the STORE DESC must be at the first
column.

Try rearranging your table if possible.

Thanks

Shail


Daniell wrote:
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.