Vlookup into List box - HELP PLEASE

[shaunkaz]

Hi, Ill try and explain as best as I can

Sheet 1 - Cell D5, We input our product Reference, In Cell E5 I want this to look our our database to see which tool is avaialable. (This also happens on every row down ie. D5, D6, D7 etc.. )

Sheet 2 = Database - Column "C" C7:C1000 contains all product references, Column "Z" Z7:Z1000 contains all the tool numbers

On Sheet 2 there may be some duplicate product references but different tool numbers.

Example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column C = Product Ref[/TD]
[TD]Column Z = Tool Number[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bottle A[/TD]
[TD]89[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bottle A[/TD]
[TD]150[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Sheet 1 - Depending what reference is typed D5 I want E5 to be a list box so the operator can choose which tool is to be used.

This list box will then need to be dragged or duplicated down the sheet.

Thanks
Shaun