Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Chisisi Massri   on Jan 14 In MS Office Category.

vlookup and error


  
Question Answered By: Harriet Ward   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)

Share: