=INDEX($A$1:$A$65,SMALL(IF($B$1:$B$65=I$4,ROW($A$1 :$A$65)),ROW(1:1))
array entered (ctrl + shift + enter)
and copy the formula down
cell A1:A65 holds the values which you want to lookup
Cell I4 is the criteria that you want to use to search the other table
Cell B1:B65 holds the critera in the looked up table

Its going to give an N/a when it fininshes all the values that are looked up
and can be hidden easily usig conditonal formatting


"jddtct" wrote in message
...
I am attempting to use the VLOOKUP command to search a column of dates and
return data associated with each date. The column of dates which I am
searching has multiple entries of the same date. The VLOOKUP command
wants
to only return data associated with one of the dates and ignores the
remaining matches. Is there a way to make VLOOKUP return data associated
with multiple matches? Is there another function that suits this
requirement
better?