Hi,

I am using the following array formula to copy certain text from another cell:

=INDEX(E1:E100,MATCH(1,IF(A1:A 100=Selections!J4,IF(ISNUMBER(MATCH(E1:E100,{"F ","U"},0)) ,1)),0))

I am getting the #N/ A error in the cell when the source cell contains something other than "F" or"U". I have tried to wrap the ISERR command around the formula but this does not seem to work. Is there another way of getting rid of the #N/A and just leaving a blank cell?

Thanks,

James