Insert Missing Dates By Comparing Two Lists Of Dates

[Admin]

@ Trebor76

IFERROR won't work in pre-2007 versions.

try this

=if(isnumber(match(D4,$E$4:$E$19,0)),VLOOKUP(D4,$E $4:$E$19,1,0),TEXT(0,"Genera l"))

[Trebor76]

@ Admin,

Yes I know ISERROR was released with 2007 (I didn't post that solution BTW).

Like the solution posted by aju.thomas, your solution again only works till 8-Jan and has an extra space between "a" and "l" in "General" (must be a formatting issue with the web page).

Robert