Thread: use if statement in excel formula to populate adjacent from list?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default use if statement in excel formula to populate adjacent from list?
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
wrote:

Is it possible to create a formula using an if statement to populate an
adjacent cell from a list/dropdown of text?

Reply With QuoteReply With Quote