here is my data ( FIG 1)from another sheet, i am trying to build in another sheet ( FIG2) using the INDEX and COLLECT fmla, however i kept on getting #INCORRECT ARGUMENT SET.
my fmla were :
=INDEX(Collect("my range is the column of row ID up to the column of #7 in FIG1", "Row id", "code"),1)
=index(collect("my range is the column of row ID up to the column of #7 in FIG1","range of row ID in FIG1,"row iD in FIG2","column of ROw ID fig1",column of code in FIG2),1)
thank you for your assistance
Help Article Resources
Check out the Formula Handbook template!