Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

combining formula

  Asked By: Arland    Date: Aug 24    Category: MS Office    Views: 777
  

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: 

 

No Answers Found. Be the First, To Post Answer.

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




Tagged: