Need help in Combining If formula with Vlookup

[Excel newbie]

I am tring to create a formula with the IF and Vlookup function to
return whether or nor an account is "new" or "exisiting". To make
thingsdifficult, the lookup is coming from two different source.

Lets say I have column A as point of reference, where all accounts
are. I would like to create a formula on column B where IF "A1" is
equal to any accounts listed "C1 to C3", return "exisitng", if not
look at "D1 to D3" iF "A1" is equal to any accounts listed return
"exisiting", if not "new"

I was using formula If(a1=Vlookup(a1,c1:c3,1,false),"exisitng",if
(a1=Vlookup(a1,d1:d3,1,false), "exisiting", "new")

Need anyones input about this!!! much appreciated!!!!!!!

 

[Lars-Åke Aspelin]

I am tring to create a formula with the IF and Vlookup function to
return whether or nor an account is "new" or "exisiting". To make
thingsdifficult, the lookup is coming from two different source.

Lets say I have column A as point of reference, where all accounts
are. I would like to create a formula on column B where IF "A1" is
equal to any accounts listed "C1 to C3", return "exisitng", if not
look at "D1 to D3" iF "A1" is equal to any accounts listed return
"exisiting", if not "new"

I was using formula If(a1=Vlookup(a1,c1:c3,1,false),"exisitng",if
(a1=Vlookup(a1,d1:d3,1,false), "exisiting", "new")

Need anyones input about this!!! much appreciated!!!!!!!

Try this formula:

=IF(ISNA(VLOOKUP(A1,C1:C3,1,FALSE)),IF(ISNA(VLOOKUP(A1,D13,1,FALSE)),"new","existing"),"existing")

Hope this helps / Lars-Åke

 

[Excel newbie]

Try this formula:

=IF(ISNA(VLOOKUP(A1,C1:C3,1,FALSE)),IF(ISNA(VLOOKUP(A1,D13,1,FALSE)),"new­","existing"),"existing")

Hope this helps / Lars-Åke

HEY THIS WORKS GREAT - AND THANK YOU VERY MUCH!!!!