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
Bookmarks