vlook up return more than one match

please help

i have a customer work book for outstanding orders of which there are hunderds of rows with there name order number and the items that are outstanding

when i have progressed all my purchased orders i take all the items and run it throught my work book using vlookup to return who wanted what items if any

but what if there are more then one customer wanting the same item how can i get vlookup to know that and return the next match


i'm still very new at excel so can someone please help me

attached is a small test of my work book

if you see item 3182Y/1.0/BLK
you can see it is wanted by both a.f switchgear and amg

but it will only return a.f switchgear