Try...

=(INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<"" ,0))+12)*100

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Steved wrote:

Hello from Steved

I have 2 columns one with
=INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5<"", 0)) and the second with
=(D2+12)*100

Please can i combine the above formula.

Ok the first column brings in 1.00 the second column changes it to 1300
so instead of creating another column just have the one column with 1300 in
it
Thankyou.