Can VLOOKUP return multiple answers based on several identical lo.
 

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?

=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?

No single function. You can set up a series of formulas to look down the
"index" column and return the row number of any matching entries. Then you
can use the small function to successively pull out these matching row
number, then use each to pull back the associated value. this is done with
array functions.

It is pretty specific to how the data is laid out. If you need more help,
contact me at or perhaps someone else will give you an
assumed situation and give you a sample formula.

--
Regards,
Tom Ogilvy

"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?

You could apply a filter to the date column.
Data Filter Auto filter then choose the date you are interested in.

Carlos

"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?