I have a formula that works fine, it looks up a column (Detail!$DS$5:$DS$100) and returns the relevant entry in another column (Detail!$B$5:$B$400) if the first column (Detail!$DS$5:$DS$100) is equal to "None", it then returns the 1st/2nd/3rd entry of this, based upon the specified ROW(A1) etc.

(Detail!$DS$5:$DS$100) is a column containing either: blank, "None" or an "N/A" error
(Detail!$B$5:$B$400) contains a code number

My formula is:

=INDEX(Detail!$B$5:$B$400, SMALL(IF("None"=Detail!$DS$5:$DS$54, ROW(Detail!$DS$5:$DS$54)-MIN(ROW(Detail!$DS$5:$DS$54))+1, ""), ROW(A1)))

This works if there are no "N/A"

I want to try and make this formula ignore errors in row Detail!$DS$5:$DS$100. Currently if there are any N/A then it will mess up the entire formula. So im thinking somewhere i need an IFERROR embedded but i cant figure it out? or maybe an (IF(ISNUMBER....

Hopefully this makes sense,

Thanks in advance!

Mike