Hi
I have a list of items that are to happen on a specific date e.g.
31/08/2011 Main Brochure
I then have a list of dates on a different sheet e.g.
28/08/2011
29/08/2011
30/08/2011
31/08/2011
01/09/2011
and I'd like the 'Main Brochure' text to appear in the column next to the relevant date in the list sheet.
I currently have the formula
=VLOOKUP(A1,List!A1:B6,2)
which returns 0. fine for the cells where there should be nothing but the 31/08/2011 is showing 0 as well rather than "Main Brochure"
I've tried turning the dates in to numbers but that doesn't work either.
Thanks in advance of any kind assistance
M
I have a list of items that are to happen on a specific date e.g.
31/08/2011 Main Brochure
I then have a list of dates on a different sheet e.g.
28/08/2011
29/08/2011
30/08/2011
31/08/2011
01/09/2011
and I'd like the 'Main Brochure' text to appear in the column next to the relevant date in the list sheet.
I currently have the formula
=VLOOKUP(A1,List!A1:B6,2)
which returns 0. fine for the cells where there should be nothing but the 31/08/2011 is showing 0 as well rather than "Main Brochure"
I've tried turning the dates in to numbers but that doesn't work either.
Thanks in advance of any kind assistance
M