L Larry 44 Dec 7, 2008 #1 Is it possible to create a formula using an if statement to populate an adjacent cell from a list/dropdown of text?
Is it possible to create a formula using an if statement to populate an adjacent cell from a list/dropdown of text?
G Gord Dibben Dec 7, 2008 #2 The IF statement would have to be in the adjacent cell. Formulas cannot push results to another cell. How many items to choose from in the dropdown? If many, probably best to go with a lookup table and a VLOOKUP formula in the adjacent cell. If only a few you could use something like this. =LOOKUP(B1,{"one","two","three","four"},{"A","B","C","D"}) Gord Dibben MS Excel MVP On Sun, 7 Dec 2008 12:18:08 -0800, Larry 44 <Larry
The IF statement would have to be in the adjacent cell. Formulas cannot push results to another cell. How many items to choose from in the dropdown? If many, probably best to go with a lookup table and a VLOOKUP formula in the adjacent cell. If only a few you could use something like this. =LOOKUP(B1,{"one","two","three","four"},{"A","B","C","D"}) Gord Dibben MS Excel MVP On Sun, 7 Dec 2008 12:18:08 -0800, Larry 44 <Larry
