Excel - Finding x and y values through Maximum Value

[Afonsogjro]

Hello, Good afternoon.

I'm new in this forum, I normally solve my questions all by myself, cheking the internet.
But in the last few days, i steped into a problam that i can't seem to get rid of, and it seem so simple, tryed some Vlookup, Match Function, but it doesn t seem to function the right way, sometimes it gives me the correct value other times it gives me N/A

witch i find it strange.
So I want the correpondent x and y values in different cells of the maximum %, it seems easy but i can t seem to get :/
All help is welcome.

Thank you. Hope you understood if you didn't i ill post a picture it may be more easy to understand what i am looking.

https://ibb.co/gCAsU7

 

[Legacy 143009]

Based on your data;

Day =INDEX($D$3:$J$3,SUMPRODUCT(($D$4:$J$13=$D$18)*(COLUMN($D$3:$J$3)-COLUMN($D$3)+1)))
Hour =INDEX($K$4:$K$13,SUMPRODUCT(($D$4:$J$13=$D$18)*(ROW($D$4:$J$13)-ROW($D$4)+1)))

Have a nice day

 

[Afonsogjro]

Omg Mr. Flashbond! Thank you so much sir!
You have no ideia I was thinking for days, how i am going to solve this problam, i search but nothing seemed to work, and now you got me a perfect answer it gives me 100% result!
Thank you so much!

 

[Legacy 143009]

Omg Mr. Flashbond! Thank you so much sir!
You have no ideia I was thinking for days, how i am going to solve this problam, i search but nothing seemed to work, and now you got me a perfect answer it gives me 100% result!
Thank you so much!

Your welcome. Happy for it worked!