Date comparison query

[jp001]

I need to compare a column of dates in Column C to dates in Column M, and where
the date in M is a match, copy the number in that row at Column L to Column J. (Hope
that was clear enough ) Any help greatly appreciated

[Pete_UK]

You can put this formula in J2:

=IFERROR(INDEX(L:L,MATCH(C2,M:M,0)),"")

then copy down.

Hope this helps.

Pete

[jp001]

Thanks Pete, tried that and just get a #NAME? error.

[Pete_UK]

That error message means that you have mis-spelt one of the function names - did you spell IFERROR exactly as it occurs? It is better to copy the formula from here and paste it into the formula bar with J2 selected, then press < Enter >.

Hope this helps.

Pete

[jp001]

Forgot to mention - using Excel 2000, that may be the problem.
I've got a much later version, but found it a pain for some reason I don't recall just at the
moment so went back to the old version.

Actually just tried it without the IFERROR and works great - should have tried that before!


Thanks Pete!

[Pete_UK]

Which part of the formula is being highlighted (if any)?

Are you using an early version of Excel (i.e. 2003 or earlier)? The IFERROR function did not appear in Excel until the 2007 version.

Hope this helps.

Pete