find next date based on cell value

[bdrilling33]

I am needing a formula (or VBA) to enter a date that can be found on another sheet based on a number found on the first sheet. the date that would be found and entered would need to be greater than of equal to a date found on the first sheet and would need to be the first one found that met said criteria. attached is the sheet I am working on and an example of the results. The long term goal is to sort by inventory ID and date so that a time line of each ID can be followed line by line. Both data sets are pulled from SQL queries, I just couldn't get it to do what I was needing all in one.

example.xlsx

[tim201110]

=index(Sheet2!$B$2:$B$24960,match(1,(Sheet2!$B$2:$B$24960>$L2)*(Sheet2!$C$2:$C$24960=$G2),))as CSE

[bdrilling33]

I get an error when trying to enter the formula???

[martindwilson]

check the separators they should all be either , or ; not mixed

[bdrilling33]

Well, that made the formula work, but I am getting wrong results....it seems as though it is getting the date that is 2 after the previous date...

[martindwilson]

its missing the arguement for exact match
you need to find the first time both are met so match()needs to be exact
=INDEX(Sheet2!$B$2:$B$24960,MATCH(1,((Sheet2!$B$2:$B$24960>$L2)*(Sheet2!$C$2:$C$24960=$G2)),0))

[tim201110]

its missing the arguement for exact match

are you sure of that?

[martindwilson]

it whats supposed to be there just putting , actually assumes that though but is not correct syntax ,you should try to use what the help file shows or its not clear what has been done
mind you i tried your formula again and it works as per op requirements i suspect op had put the index or match range starting from the wrong cell