Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jddtct
 
Posts: n/a
Default 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?
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

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



  #3   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

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?



  #4   Report Post  
CarlosAntenna
 
Posts: n/a
Default

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup with multiple lines of same value lostinexcel Excel Worksheet Functions 1 December 17th 04 03:06 PM
VLookup Return Value Kevin Excel Worksheet Functions 4 December 3rd 04 04:05 PM
Can vlookup return multiple matches in a single cell? cchristensen Excel Discussion (Misc queries) 3 December 2nd 04 02:56 AM
Multiple Vlookup? changeable Excel Worksheet Functions 0 November 9th 04 12:52 PM
How to look up and return multiple values Wendy Excel Worksheet Functions 3 November 3rd 04 05:32 PM


All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"