| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Problem with IF condition or vector lookup?
Inserting more than 8 conditions into one cell?
Hi, I'm trying a basic look of 8 conditions, but it seems that the formula is too long. I've tried to use lookup but I can't get it to show the cell results instead of a specific number or letter. I'm just trying to do this in one cell (i.e in cell C16): if cell A13=1 show result content of cell B54 if cell A13=2 show result content of cell C54 if cell A13=3 show result content of cell D54 if cell A13=4 show result content of cell E54 if cell A13=5 show result content of cell F54 if cell A13=6 show result content of cell G54 if cell A13=7 show result content of cell H54 if cell A13=8 show result content of cell I54 I just can't get it to work. Anybody could tell me what the formula in cell C16 should look like? Thanks a lot J-Philippe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Baffling formula problem | Excel Discussion (Misc queries) | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
| Add condition to formula | Excel Worksheet Functions | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Threaded Mode
