Retrieving 'current' data

[tommo]

JAN FEB MAR
DESCRIPTION Current Price
1.5oz Round 6 5 6
45ml Hex
4oz Hex
4oz Rd

Help please!!!
I have the above spreadsheet. I am using this as a master sheet in a costing
calculation. My costing sheets link into this to always have the 'current'
price of purchsed products. Because i always need the current price to be
'current' i need the current price column to pick up the most up-to-date
information. Is there a formula (i am guessing using IF statements) that i
can put in the current price cell that will automaically pick up a new price
if i update the MARCH column?

Any help would be appreciated.

 

[Gary''s Student]

=LOOKUP(2,1/(C2:IV2>0),C2:IV2) and copy down

 

[Max]

You've also got responses at your other, earlier post

---