Need help in Combining If formula with Vlookup

E

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!!!!!!!
 
L

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,D1:D3,1,FALSE)),"new","existing"),"existing")

Hope this helps / Lars-Åke
 
E

Excel newbie

Try this formula:

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

Hope this helps / Lars-Åke

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top