I am using this
formula:=INDEX('Raw-MasterList'!$A$1:$H$1511,SMALL(IF('Raw-MasterList'!$G$3:$G$1511='Common&Tail ODIs'!$A3,ROW('Raw-MasterList'!$G$3:$G$1511)),V$2),2)
to pull multiple pieces of information from one part of a spreadsheet to
another
Some of my rows have more items than others so the #NUM! error appears, I
tried to get rid of it by adding IS(ERROR to the formula like so:
=IF(ISERROR(INDEX('Raw-MasterList'!$A$1:$H$1511,SMALL(IF('Raw-MasterList'!$G$3:$G$1511='Common&Tail
ODIs'!$A3,ROW('Raw-MasterList'!$G$3:$G$1511)),V$2),2)),"",INDEX('Raw-MasterList'!$A$1:$H$1511,SMALL(IF('Raw-MasterList'!$G$3:$G$1511='Common&Tail
ODIs'!$A3,ROW('Raw-MasterList'!$G$3:$G$1511)),V$2),2))

For some reason this isn't working the way it should, it is causing all
cells to become blank, even if there is no error, and in one column of cells
it creates data where none should be

Hope this makes sense, any help is appreciated!