Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down lists that populate other cells | Excel Discussion (Misc queries) | |||
Populate time by using a drop down | Excel Discussion (Misc queries) | |||
Using a drop-down list along with an auto-populate drop-down | Excel Discussion (Misc queries) | |||
drop down then populate | Excel Discussion (Misc queries) | |||
Populate Drop Down List | Excel Worksheet Functions |