double vlookup, is it possible?

i would like to lookup part code in different warehouse (about 10 different whse.)

the current vlookup for part number that i have only return the 1st value (color), but not the 2nd, or 3rd color. (because they have the same part number)
is there away to get around this?
pls see attachment