Hi guys,

I have some share pricing data (please see attached workbook)

My goal is to have a formula for B6 so that it looks up the maximum price in column K based on the Pricing Date (column I) which is based on the Period (A6). In other words, I would be able to change A6 from June 2010 to say July 2010, and B6 would automatically look up the max price in K26:K47 instead of me having to manually go through and alter the range from K4:K25 each time I want to change the Period month.

Any help would be much appreciated!

Thanks

Book2.xlsx