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

--
Gary''s Student - gsnu200770


"tommo" wrote:

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.