I have two columns with DATE and VALUE. I want to return the DATE based the highest value in VALUE. I have tried vLookup, based on my array; however, I want to lookup the second column and return the first. Is this possible?
I have attached a small sample.
Thanks,
Steve K.
Bookmarks