i am trying to do a lookup function for a chart i use.

what i am trying to do is create a list of counts that i do on parts for work.
at the moment i can look for a count using a part number and it will list
it with the other details but i need it to look for all counts for the same
part number and list them all.

i have

lookup
part , rev , desc , date , card , on hand , count ,
adjust
(X)

if i enter part number into (x) then it will show the information in the
count dated (31/10) from the table below. This table could contain 1000's of
parts so just want to be able to pick out certain numbers to avoid scrolling
through them all

part , rev , desc , date , card , on hand , count ,
adjust
1234 01 cap 31/10 123 5 4
-1
1234 01 cap 01/10 129 10 11
+1
4567 03 nut 01/10 140 20 19
-1
the function i currently use is

=VLOOKUP($B$7,$B$13:$J$108,2,FALSE) this is function in colunm (2) rev

i enter the part number into a box and it looks for the part number but
stops at the first one it comes to. Ideally i need it to show all counts on
the same part number possibly up to 4 counts per year.

i tried to attach a copy of the sheet but can't, hope this is enough
information to go by for you very clever people out there