Not a Normal Vlookup

[DaGoose]

I have several columns with info, one column Lets say it is "D" has a date, Column "G" has a dollar amount. The dollar column "G" is updated daily with the current price from our supplier, the date column is also updated daily, Now My problem, I need to find the MAX value in Column G post it in another cell then get the corresponding date in Column D and post it in a differrent location as well. The information is not in order to use a Vlookup table. I use the MAX(G:G) to find the dollar value but how do I get the date from 3 columns to the left to post to a new cell? The dollar amount changes just like the stock market so Our price is depended on this amount. I know nada about VBA so a formula would be very helpful Any takers?
Lost with at deer in the headlike look!

 

[lenze]

See this VERY similar thread
http://www.mrexcel.com/forum/showthread.php?t=376459
lenze

 

[DaGoose]

Thanks, I had to tweek it a tad but I got it to work. Now I have to try and understand what it is doing so i can learn from it. Thanks for the help.