Hi,

I am new here and would be really thankful for any help I can get!

I have to workbooks. In the first you'll find the information on Category and the different Items in each Category. In the secound I need to creat in Cell A and Dropdown List with the different Categories and in Cell B the correnponding List to what is found in cell A should be displayed.

I am able to set everything up, as long as they are in one workbook (with help of the Indirect Formuala), however it always shows an error as soon as I try to with the 2 workbooks.

For the first dorpdown List I was able to trick Excel with help of the Name Manager Function, however that does not seen to be able for the second.

If anyone has an Idea on how to proceed - that would be awesome!

(Unfortunatly my Manager wants Ecxel Formulas only so no Makro, VBA etc.)

Thanks,
Hannah