is it possible to combine the following togetherin colum "B" =vlookup(A2,$J$2:$M$2000,False,2)andin colum "D" =if(iserror(B2),"A",B2)if as some times happens colum "B" gives readings as " #N/A "is it possible to combine the two functions so that only one colum isrequired instead of the two i am using at present.
=IF(ISERROR(VLOOKUP(A2,$J$2:$M$2000,2,FALSE)),"A",VLOOKUP(A2,$J$2:$M$2000,2,FALSE))Note that in my version of excel=vlookup(A2,$J$2:$M$2000,False,2)had to be written:=vlookup(A2,$J$2:$M$2000,2,False)