Good Day to all of you
I have a file for stock control where i need to see when last time we sell a product.
i need a formula in column U which bring the header value in it if that column has got a number value.
Column G is Item Ref.
Column H is Item Description
Column I to T are the columns where i have my Quantities sold in those months
for Example
Item Ref 1 has been sold in April Last time i am looking for a formula which can print the value of cell S7 here in Cell U9
File is attached for your reference...
thanks for your help.
Kind Regards
I have a file for stock control where i need to see when last time we sell a product.
i need a formula in column U which bring the header value in it if that column has got a number value.
Column G is Item Ref.
Column H is Item Description
Column I to T are the columns where i have my Quantities sold in those months
for Example
Item Ref 1 has been sold in April Last time i am looking for a formula which can print the value of cell S7 here in Cell U9
File is attached for your reference...
thanks for your help.
Kind Regards