Find out the parameters from data table

[alee001]

I am new user from hong kong, anyone can solve my problem as attached excel file which is how to search out two parameters from optimization after data table result?
thks a lot....

[FDibbins]

maybe its just me, but what exactly are you trying to find there? and where do you want the result shown?

[alee001]

Sorry, I have not ideal how to write VBA code to find out the two parameters after result (max value) of using excel data table fuction? (I only find out the two parameters base on INDEX and MATCH fuction with attached file) Could you any advise for me?

[FDibbins]

If you could explain to me what you are trying to find, and where you want the answer shown, im sure we can help you.

In your example, which number are you trying to find, based on what? manually finding what you want in your table, and showing how you found it would be a great help

[alee001]

I found the max value (may be more than one) after using fuction data table then the two parameters are indicated that x and y on array table separately, now I want to get the x and y parameters by VBA automatically, how to do it? thanks...