Hi everyone,

Have managed to get stuck again on a new problem with dropdown list boxes.

I now have 2 list boxes on a worksheet both working with data sourced from another worksheet in the same workbook.

One list box contains names and the other ID numbers. These are linked to the source worksheet using named ranges.

My aim is to link the 2 list boxes so that if a user selects a name in one list box the corresponding ID number also appears in the other list box. Likewise I need it to work in reverse, thus giving the user 2 means of searching for a customer.

The results in each cell will also be used to produce additional information.

I did quite a bit of searching for a solution to this problem but nothing came up that seemed to solve this problem.

Hopefully, someone has come across this before ....spellbound