I don't see that either <grin
There are multiple argument lookups, but I think the
poster would be more interested in filtering.

choice wrote:
i have a range (a1:g5000) sorted by date, the same date can be used
in multiple rows, i need to lookup up a date and have it return all
info for each dateseld be

A little bit light on how they want to to the lookup, whether they know
the date or have to look it up first. Debra Dalgleish, I think, has some
program invoked filter examples on her site. http://www.contextures.com
look for filter or filtering.

Since the question is skimpy on what is wanted it probably
is is not a programming question. So perhaps a simple filter
is all that is needed.

Auto Filter within...
Summarizing Data Examples (an Overview)
http://www.mvps.org/dmcritchie/excel...htm#autofilter
Also includes information to undo the filter, don't want anyone having
to restore a file because how to undo wasn't included.


--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Alan Beban" wrote in message ...
Frank Kabel wrote:
Hi
use VLOOKUP (multiple) for this. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

I don't find any section or heading VLOOKUP (multiple)

Alan Beban