Lookup closest subsequent date

[RollingStone88]

Hi.

I have two tables that are tracking different processes (simplified on table 1 and 2 of the attached).

I need a way of linking the chronologically closest date value found in table 2 into table 1 - but the date being carried over must be after' the date value in table 1.

Column C contains the desired output.

Hope this makes sense. Please let me know if I need to clarify anything further & thanks for helping.

Thanks

[KOKOSEK]

I am not mistype anything (into C3):

Please Login or Register  to view this content.

accept with Ctrl+Shift+Enter as it is array formula.

[AliGW]

In C3:

=IFERROR(1/(1/MIN(IF($F$3:$F$12=A3,IF($G$3:$G$12>B3,$G$3:$G$12)))),"")

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Then drag copy down.

[RollingStone88]

It works - thank you both