In a worksheet (Ansatte) i am having a column with names in the range A4:A41, i named the range "Navne".
These names are copyed to 8 other sheets.
On these sheets code is looking up corresponding values in the sheet (Ansatte) in columns D, E and F and showing the name and these values in the statusbar.
In order to have the lookup working correct the names must be unique and contain no space.
I attach the sheet in question.