Hi
use VLOOKUP (multiple) for this. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

--
Regards
Frank Kabel
Frankfurt, Germany


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 date