vlookup to populate drop-down
 

I am trying to use multiple vlookups to return a specfic value
on sheet1 column a is the device name column b is the discription column c
is the final lookup value.
on sheet2 is my data
column a is the abreviation column b is the description column c is the
final value
sheet 1
Column a is typed in Column b i want to pick from a drop down list that
would be abbreviation specific Column c is attomatically filled in based on a
and b
A B C
PB1000-30 RED HPB2R
PB1000-40 BLUE HPB2B
PB1000-10 GREEN HPB2G
PB1000-20 GREEN HPB2G

sheet 2 (fixed data)
A B C
PB RED HPB2R
PB GREEN HPB2G
PB BLUE HPB2B
CR NO HCR21
CR NC HCR22

Any suggestions?...Wish i could post some sreen shots...