is it possible to combine the following together
in colum "B" =vlookup(A2,$J$2:$M$2000,False,2)
and
in 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 is
required instead of the two i am using at present.