Hi all,
I have a vb function that enters a formula into a work sheet but I seem to have made an error and I can't for the life of me see it.
Actc is the column
Rw is also the column
When I just stepped through the code actc = 21 and Rw =U
Vb formula:
The output should be in excel terms
Any help would be marvellous!
Dan.
Who is looking forward to 5:30
I have a vb function that enters a formula into a work sheet but I seem to have made an error and I can't for the life of me see it.
Actc is the column
Rw is also the column
When I just stepped through the code actc = 21 and Rw =U
Vb formula:
Code:
Cells(14, Actc).Formula = "=IF(VLOOKUP($C$3,Data!$A:$EU,(118+Report!" & Rw & "1),0)=123456,IF((INDEX(ServT,MATCH((" & Rw & "15/$L$4),INDEX(ServT,,2),-1),4))=R,(ROUNDUP((AVERAGE(" & Rw & "12:Offset(" & Rw & "12,0,3))*(INDEX(ServT,MATCH((" & Rw & "$15/$L$4),INDEX(ServT,,2),-1),3)))+$L$4*$I$6,0)),(INDEX(ServT,MATCH((" & Rw & "15/$L$4),INDEX(ServT,,2),-1),3)*$L$4)+($I$6*$L$4)),VLOOKUP($C$3,Data!$A:$ET,(118+Report!" & Rw & "1)))"
The output should be in excel terms
Code:
'=IF(VLOOKUP($C$3,Data!$A:$ET,(118+Report!U$1),0)=123456,IF((INDEX(ServT,MATCH((U$15/$L$4),INDEX(ServT,,2),-1),4))="R",(ROUNDUP((AVERAGE(U$12:OFFSET(U12,0,3))*(INDEX(ServT,MATCH((U$15/$L$4),INDEX(ServT,,2),-1),3)))+$L$4*$I$6,0)),(INDEX(ServT,MATCH((U$15/$L$4),INDEX(ServT,,2),-1),3)*$L$4)+($I$6*$L$4)),VLOOKUP($C$3,Data!$A:$ET,(118+Report!U$1)))
Any help would be marvellous!
Dan.
Who is looking forward to 5:30