Hi, I have a dropdown list populated by another worksheet using a dynamic named list (inventory).

I would like to have cells adjoining my dropdown box automatically populate when I make a selection from the list using the data in cells adjoining that item in the other workbook (in this case specs on that inventory item).

Can you help?