hi.
i am a problem in this formula i want to add more colums in this how to do this plzz solve if possible
i want colum , F ,G ,I ,K ,L, M, N from my summary sheet the amount in diffrent row every time. one time in F second time may be L, its pick data from summary!f:f only
IF(ROW($A2)>$C$1, "", INDEX(SUMMARY!F:F, MATCH($B$1 & "-" & ROW($A2), SUMMARY!$S:$S, 0)))
thanks ,
Bookmarks