I'm trying to use an array to select and use specific data from a list.

The data range is 4 coloumns like: Name , Department, City, Salary

On another worksheet I have a drop down to select a a name from the Name
cloumn, and an array formulas in the following 3 coloumns to select
corresponding value for this specific employee:

Department: {=IF(E4=Employees,Department,"Unknown")}
City:{ =IF(E4=Employees,Office,"Unknown")}
Salary: {=IF(E4=Employees,Salary,"Unknown")}

*Employees, Office, Department, Salary are all names of corresponding ranges.

So the problem is that all the arrays work only with the first line in each
coloumn. So that I'm only able to make Excel feed in the required data for
the very first employee in the list. I can select the names of other
emplyees, but only FALSE condition is shown for them.

Does anyone have a solution?

Thank you for help.