|First, a posting tip:|
If you click on the blue line at the end of this post you will find the instructions on how to format example data so that it is easier for us to read. In the future, please use that method. Don't forget to use Column letters and Row numbers as shown in the example. Thanks!
As for your question, if you start with this layout, then formula below should work for you:
A B C
1 Project status Project positions Total project steps
2 1.Wachten 8 8
3 2.In ontwerp 8 8
4 3.Tergoedkeurin 8 8
5 4.Gelanceerd 8 8
6 5.Production 8 8
7 6.Afgett 0 8
8 7.Deellevering 0 8
9 8.Geleverd 0 8
11 Project # Project status
12 150565 5.Production
Put this in B2 and drag it down:
This formula uses the MATCH function to determine the position in the array (A2:A9) of the value in B12. If the position is Greater Than or Equal To the position of the "status" in Column A, then an 8 is returned.
Please note that the MATCH function does not return the Row number of the lookup_value, it returns the position in the lookup_array.
e.g. 5.Production is in Position 5 of the lookup_array (A2:A9) even though it is in Row 6 of the worksheet.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03