Using INDEX(MATCH()) with dates

Are the dates numbers or text that look like dates?

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

1. your dates in CSGL sheet include time, so no pure dates will match them. You need to strip out the times\

2. avoid using full-column references in ARRAY formulas, they will slow your file down - just use the range you need

Could you show me how to strip out the times from the dates?

=TEXT(LEFT(B2,LEN(B2)-6),"dd-mm-yyyy")*1 and format as date

for which cells you get an error?

you have to give us all the information to get a decent answer.

another way use text to column and use space as a separator.

excel file attached.

If you are getting an error from oelere's formula, then those are probably not dates, but text looking like dates

Another way to strip time =INT(cell-ref)

Thanks for marking the question closed.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.