vlookup to populate drop-down

I

Isitfridayyet

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find value based on two lookup values 2
Cobditional Formatting Rows based on dates in action plan. 0
Drop down lists in seperate columns 5
Help with formula 0
Need to reorganize - transpose columns to rows per article number 1
Assigning a value to one cell based on the date in another... And then doing it again 0
Drop down list control value in vba 2
dependent, multiple variable, drop down list 2

Top