G
Guest
i have a range of data (a1:g5000) sorted by date. some of the rows have the same date, how could i go about looking up all the info for a certain date. i tried vlookup, but it return one row and kept looking it up. any help would be greatly appreciated