HI frinds,
i need a VBA code to replace below vlookup formula in each rows in T column till the data ends. My formula (given) starts in T2.
=IF(V3>0,IF(P3<>"",Q3-1,T2),IF(P3<>"",IF(V3+VLOOKUP(Q3,Deal!D:F,3,0)>0,Q3,IF(V3+VLOOKUP(Q3,Deal!D:F,3,0)+VLOOKUP(Q3+1,Deal!D:F,3,0)>0,Q3+1,"no fund")),IF(V3+VLOOKUP(T2+1,Deal!D:F,3,0)>0,T2+1,IF(V3+VLOOKUP(T2+1,Deal!D:F,3,0)+VLOOKUP(T2+2,Deal!D:F,3,0)>0,T2+2,"no fund"))))
i need only the resulted value only to be updated in T2, that's y i need it VBA. I'm not an expert in VBA but i do some by using recording function.
it would be grateful if someone could help me.
Thankyu,
vimal
i need a VBA code to replace below vlookup formula in each rows in T column till the data ends. My formula (given) starts in T2.
=IF(V3>0,IF(P3<>"",Q3-1,T2),IF(P3<>"",IF(V3+VLOOKUP(Q3,Deal!D:F,3,0)>0,Q3,IF(V3+VLOOKUP(Q3,Deal!D:F,3,0)+VLOOKUP(Q3+1,Deal!D:F,3,0)>0,Q3+1,"no fund")),IF(V3+VLOOKUP(T2+1,Deal!D:F,3,0)>0,T2+1,IF(V3+VLOOKUP(T2+1,Deal!D:F,3,0)+VLOOKUP(T2+2,Deal!D:F,3,0)>0,T2+2,"no fund"))))
i need only the resulted value only to be updated in T2, that's y i need it VBA. I'm not an expert in VBA but i do some by using recording function.
it would be grateful if someone could help me.
Thankyu,
vimal
