Thanks Whizbang but i don't think this will work for what i am trying to do.

I need to select from a dropdown the country i want to view in column A, then it populates dropdowns in columns B, C & D with the Products, Customers and Suppliers applicable to that country in A.

Does that make sense? I am really bad at explaining these things, but i suppose the best way of describing it would be i want 3 seperate dropdowns in three seperate columns dependant on my choice of country in column A.

As i can only name one field UK (for example) i can't use the =INDIRECT function as this only returns one field of data.