Look Max date and return value from an offset cell

[jl2509]

Hi all

I wonder if someone can help me out here.

I am looking to find the "Next Phase Due Date" from the data in B3:H5
The next Phase Due Date to be shown in Cell C11 should be 25/11/23 as this is next phase baseline date where the phase has not yet been completed as indicated by "N/C"
I would also like to show the next phase due in Cell C9, and in this case it would be "Phase 4"

I am not sure how to lookup across the dates and return the values required.

Any help is much appreciated

 

[Fluff]

How about in C9

=XLOOKUP("N/C",C5:H5,C4:H4,"")

and change the range from C4:H4 to C3:H3 for C11

 

[jl2509]

Hi Fluff
Works a treat, thanks for the support

 

[Fluff]

You're welcome & thanks for the feedback.