Vlookup / Index array issues

Hello everyone,   I am trying to solve the following problem:   I have an overview table in which projects are listed in a column. Next to each project is the project status. Now, each project h...