Forum Discussion

sksk2424's avatar
sksk2424
Copper Contributor
Nov 17, 2022
Solved

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...
  • OliverScheurich's avatar
    Nov 17, 2022

    sksk2424 

    =FILTER(B2:F15,B2:B15=A17)

    With Excel 2019 or later you can apply FILTER function.

     

Resources