Multiple list dropdown

Hi
i have 2 lists of items that i would like to choose from 1 and return another value to a cell. this would need to be available in every row of cells.
eg

these references are on a different tab 'sheet 2'
cell A cell b
row1 test1 1
row2 test2 2
row3 test3 3

the list would show both 'test1' and '1' but when i choose then the cell on 'sheet 1' would show '1'

hope someone understands this and know a way to do this
thanks
kev

Nick's picture

I think this is a vlookup

I think this is a vlookup question... more here: 

 13. Excel Tips - VLOOKUP