Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use if statement in excel formula to populate adjacent from list?
Is it possible to create a formula using an if statement to populate an
adjacent cell from a list/dropdown of text? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
lookup and populate with adjacent contents | Excel Discussion (Misc queries) | |||
Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
Populate a column of data with a formula using a drop down list | Excel Discussion (Misc queries) | |||
Excel - Sum of Values based on adjacent list selection | New Users to Excel |