MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

combining formula

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

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.



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.