Forum Discussion
gms4b
Jul 26, 2019Brass Contributor
how to combine data from two sheets using index/small in an array
I use the following formula to look in the "final" tab and return "Quality Control" data as described in the formula. =IFERROR(INDEX(final!$G$2:$G$20000,SMALL(IF("Quality Control"=final!$B$2:$B$...
tauqeeracma
Jul 27, 2019Iron Contributor
Hi Greg
Would be great if you share your file . Thanks