Logo 
Search:

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: 800
  

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.

Share: 

 

1 Answer Found

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

=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)

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




Tagged: