Excel 2007 : Offset and Min functions

I'm in need of some assistance on a function. I have attached a copy of the spreadsheet that I'm working on. What I'm trying to accomplish is to have a user enter a value in cell B5, then have a formula in a separate cell (B13) return the minimum value in the column, where the header of that column closely matches the value of what the user entered in B5.

For example, if the user enters the value of 3.2 in cell B5, it should return the value of 18.50 since that is the lowest value in that column.

I've tried an OFFSET and Match function but am having issues. Any help you can provide would be much appreciated!

Originally Posted by daddylonglegs

INDEX is often better than OFFSET as it's not volatile. Try this formula

=MIN(INDEX(BOXDATA,0,MATCH(B5,G3:AZ3)))

That worked perfect. A huge help! Thank you very much for taking the time to respond to my post!

That worked perfect. A huge help! Thank you very much for taking the time to respond to my post!