To find Weekly High and Low for the company

Hi,
I have data in column A to Column E in which name of the company,High price,Low price,date and week is mentioned.
What my requirement is that if I type in Cell H1 name of the company then in H3 I should get high price of that company for that particular week and in H4 I should get Low Price of that company.
For better understanding I have attached excel sheet.

Thanks in advance

Goodboy

Thanks for the answer. But i was actually looking for formulas

Still can't get as mentioned can somebody help with formulas

Hi goodboy, try the array formulas (ctrl+shift+enter) below:

Formula:

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin