Referencing data in the next row down that has a specific value in an adjacent cell

[Innoguide]

I have a simple 3 column worksheet as follows:

Column 1 contains either Y or N.
Column 2 contains dates
Column 3 needs to contain calculated dates as follows:

If the column 1 cell for a row = "Y", the column 3 cell in that row needs to contain the date from column 2 of that row

If the column 1 cell for a row = "N", the column 3 cell in that row needs to contain the date from column 2 of the next row down that has a "Y" in column 1.

I know how to make it conditional (=if(A2="Y",B2, ----)) but would really appreciate any help you could provide on what formula I need to use in the false argument to provide the date from the next row down that has a Y in column A.

Thanks!

 

[Aladin Akyurek]

Thanks Aladin - worked exactly as needed!

You guys all make this look easy

M

You are welcome. Thanks for providing feedback.

 

[Innoguide]

That works too Biff and keeps it simpler

Thanks

 

[T. Valko]

That works too Biff and keeps it simpler

Thanks

You're welcome. Thanks for the feedback!