I'd use vlookups to find the first and last row of the appropriate month,
then an offset function to construct the range of cells that would be my
table array for a final vlookup.
"Chiba" wrote:
Got a head scratcher. I have a list of prices and dates. I'm using a
DMAX function to get the highest price for each month, which works just
fine.
But, I want to lookup the result of the DMAX function and return the
date. That way I have a list of months, the high price and the date
that price came from. Problem is, in the whole table there are multiple
prices that are the same, so I get a #NUM error if I use DGET, or
vlookup just returns the first one.
How can I set the lookup table to check the original date criteria and
only lookup in a part of the overall table?
--
Chiba
------------------------------------------------------------------------
Chiba's Profile: http://www.excelforum.com/member.php...o&userid=24998
View this thread: http://www.excelforum.com/showthread...hreadid=385264