last price

Dear sir,with best regards,i need your help to get last price from this schedule of data :
-the range(ag5:ag500) has the names of materials.
-the range(ai5:am5) has the prices of each material.for example (A) material has these prices continually 1.6,1.8,1.9) i need the result as ( 1.9 ).
-the range(ar5:ar500) the last prices from above second range,and the cells are ( empty ) if there is no prices.
your help is very appreciated.