MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

vlookup and error

  Asked By: Chisisi    Date: Jan 14    Category: MS Office    Views: 775

is it possible to combine the following together

in colum "B" =vlookup(A2,$J$2:$M$2000,False,2)
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.



1 Answer Found

Answer #1    Answered By: Harriet Ward     Answered On: Jan 14


Note that in my version of excel
had to be written:

Didn't find what you were looking for? Find more on vlookup and error Or get search suggestion and latest updates.