I received the following code from Bob Philips that looks for the max date
for a location (between those dates in column AH) and returns the closing
stock

{=INDEX(Closing_Stocks,MAX((StoreNo="London")*(SalesDate>=$AH$1)*(Inventory_No=$H$6)*(SalesDate<="$AH")*ROW(StoreNo))-1)/10}

What I want now is to return the Opening Stock. Again I have a range name
called "Opening_Stocks". I thought it was a matter of just changing MAX to
MIN, but I'm getting a #Value appear although I'm surpressing it to return
0, my code is as follows

{=IF(ISERROR(INDEX(Opening_Stocks,MIN((StoreNo=$B$50)*(SalesDate>=$AH$1)*(Inventory_No=B9)*(SalesDate<="$AH")*ROW(StoreNo))-1)/10),0,(INDEX(Opening_Stocks,MIN((StoreNo=$B$50)*(SalesDate>=$AH$1)*(Inventory_No=B9)*(SalesDate<="$AH")*ROW(StoreNo))-1)/10))}

Any help would be great as its driving me nuts