LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
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 02:06 PM
VLookup Return Value Kevin Excel Worksheet Functions 4 December 3rd 04 03:05 PM
Can vlookup return multiple matches in a single cell? cchristensen Excel Discussion (Misc queries) 3 December 2nd 04 01:56 AM
Multiple Vlookup? changeable Excel Worksheet Functions 0 November 9th 04 11:52 AM
How to look up and return multiple values Wendy Excel Worksheet Functions 3 November 3rd 04 04:32 PM


All times are GMT +1. The time now is 06:33 PM.

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

About Us

"It's about Microsoft Excel"