Looking for some help, where I work the old system for booking out items from
our store involved a pen and paper, ive now computerised this.

I now have the staff booking out items, as I go I have been changing this to
make it more user friendly and this has included using Vlookup so the staff
only have to find the item number and the Vlookup completes the item
description.

=VLOOKUP(E2,$B$3:C749,2,FALSE)

Ive now come to a brick wall, basically 99% of our stocked items are given
unique stock numbers however we carry Consumable items (ZONNS), we have
approx 30 different items all under ZCONNS.

I have been surfing and reading articles but I cannot find the right formula
that I need, what I would like to do is for a staff member to type in the
item number ZCONNS and for it to then bring up a drop down list or similar
for us to choose the correct item to book out of store.

Below is a sample list of some of the consumables:

ZCONNS Bootlace Ferrule Violet 0.25mm
ZCONNS Bootlace Ferrule Pink 0.34mm
ZCONNS Bootlace Ferrule White 0.5mm
ZCONNS RJ11's - 4 contacts - STR
ZCONNS RJ11's - 4 contacts - Solid
ZCONNS RJ12's - 6 contacts - STR
ZCONNS RJ12's - 6 contacts - Solid
ZCONNS RJ45's - Stranded - STR
ZCONNS RJ45's - Solid
ZCONNS RJ45's - Shielded Stranded - STR
ZCONNS RJ45's - Shielded Solid
ZCONNS Resistors etc - All Sorts
ZCONNS Cable Ties pkt100x(100x2.5) Natural
ZCONNS Cable Ties pkt100x(100x2.5) Black

Any help is greatly appreciated.

Regards David