...and store repeated formulas under user name define, may help to increase the calculation speed
for example
Stay at cell I6, Ctrl-F3
name : "Something":
=IFERROR(INDEX(ARTICLES!$D$9:$D$88;MATCH(I6;ARTICLES!$A$9:$A$88;0);0);"")
...and store repeated formulas under user name define, may help to increase the calculation speed
for example
Stay at cell I6, Ctrl-F3
name : "Something":
=IFERROR(INDEX(ARTICLES!$D$9:$D$88;MATCH(I6;ARTICLES!$A$9:$A$88;0);0);"")
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks