PDA

View Full Version : dropdown menu



mtsf26
01-14-2012, 01:56 AM
hey all i have problem regarding data validation(list).

if i have sheet1 that contain :
A |B |
code |item |
1384 |glue |
2940 |box |

and i have sheet2 that contain :
A |B |
code |item |

if then i want to use dropdown menu..that refer to sheet1 and when i choose dropdown menu for item 1384 in column A sheet2 can it show the item as well in column B sheet2.thanks in advanced

uqh65q
01-14-2012, 04:25 AM
Hi mtsf26
I am new to posting onto forums so if I have got this wrong sorry.

I once had a similar problem and the following website helped me.

contextures.com/Excel-VBA-ComboBox-Lists.html

Bob Phillips
01-14-2012, 09:14 AM
Use VLOOKUP

=VLOOKUP(A2,Sheet1!A:B,2,False)

Simon Lloyd
01-14-2012, 09:21 AM
To use a list for validation from another sheet you would have to make it a named range :)

mtsf26
01-15-2012, 10:57 PM
@uqh65q hey thanks its so useful for me..i will try it too...
@xld thanks it also the solution..
@simon lloyd i also have named the range.