Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in Combining If formula with Vlookup
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!!!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining IF with VLOOKUP | Excel Worksheet Functions | |||
Combining VLookup and IF statements | Excel Discussion (Misc queries) | |||
Combining VLOOKUP functions | Excel Worksheet Functions | |||
combining a Vlookup and Mid formula | Excel Worksheet Functions | |||
combining VLOOKUP and IF | Excel Worksheet Functions |