Hi guys, so i am basically trying to incorporate indirect into the formula below.. but i am not doing very well,
someone mind fixing my error so i can learn from it? 

 =IF(ISERROR(SMALL(Pickrates!$M$6:$M$326,B6))," ",IF(SMALL(Pickrates!$M$6:$M$326,B6)<=249,SMALL(Pickrates!$M$6:$M$327,B6),""))
The original ^

=IFERROR(SMALL(INDIRECT("'" & G2 &"'!$m$6:$m$326"),B6)," ",IF(SMALL(INDIRECT("'" & G2 &"'!$M$6:$M:$326",B6))
My try ^

thanks.