Multiple IF statements with VLOOKUP

Originally Posted by RedSummer

Bebo, the projects are liable to change so using {5,7,9,11,13,15,17} hard coded won't be the best solution

I'm intent on using an OFFSET MATCH to get the right row but it's increasingly annoying to test it out. I'm nearing it though

{5,7,9,11,13,15,17} represent for {Identify, Define,...,Close} column, I think they are fixed.
And my formula also is dynamic for project number.
Basically, I use VLOOKUP(project#,range,{1,3,5,7,9},0) to establish date range of project#.
After that, compare D32 (current date) to that date range to find down the fist date that less than.

=IFERROR(INDEX('Master List of Projects'!$E$2:$R$2,MATCH(TRUE,D$32<=VLOOKUP($A6,'Master List of Projects'!$B$2:$R$33,{5,7,9,11,13,15,17},0),0)*2-1),"")

Test it again and tell me what's wrong with it.