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?
Bookmarks