If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple formulas in a single cell referencing a drop down box.
I have a drop down box in A1 with 13 different items from another sheet (same
workbook). I need a formula in E6 (for example) that says (in plain english for simplicity sake). If "AB" is selected from the drop down box then display cell B2 from sheet 2, if AC is selected then display cell B3 from sheet 2, if AD is selected then dislplay cell B4 from sheet 2.....etc. If this is confusing (may have confused myself) let me know and I can try to simplify. Can anybody help me with this. Would be greatly appreciated. |
#2
|
|||
|
|||
Multiple formulas in a single cell referencing a drop down box.
Definitely consider a VLOOKUP() table.
-- Gary''s Student - gsnu200848 "Sylvan06" wrote: I have a drop down box in A1 with 13 different items from another sheet (same workbook). I need a formula in E6 (for example) that says (in plain english for simplicity sake). If "AB" is selected from the drop down box then display cell B2 from sheet 2, if AC is selected then display cell B3 from sheet 2, if AD is selected then dislplay cell B4 from sheet 2.....etc. If this is confusing (may have confused myself) let me know and I can try to simplify. Can anybody help me with this. Would be greatly appreciated. |
#3
|
|||
|
|||
Multiple formulas in a single cell referencing a drop down box.
VLOOKUP formula in E6
=VLOOKUP(A1,Sheet2!$A$1:$B$13,2,FALSE) Assumes Sheet2 column A has list of possible selections from the DV list and column B has a list of items to return to E6 Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 13:12:01 -0700, Sylvan06 wrote: I have a drop down box in A1 with 13 different items from another sheet (same workbook). I need a formula in E6 (for example) that says (in plain english for simplicity sake). If "AB" is selected from the drop down box then display cell B2 from sheet 2, if AC is selected then display cell B3 from sheet 2, if AD is selected then dislplay cell B4 from sheet 2.....etc. If this is confusing (may have confused myself) let me know and I can try to simplify. Can anybody help me with this. Would be greatly appreciated. |
#4
|
|||
|
|||
Multiple formulas in a single cell referencing a drop down box
Thanks! That was definitely the answer I was looking for. Second question if
there is nothing in the column with the drop down box an #N/A is displayed in my E6 column. Is there a way to display a zero or nothing at all until something is selected from the drop down box?? Thanks again for any help "Gord Dibben" wrote: VLOOKUP formula in E6 =VLOOKUP(A1,Sheet2!$A$1:$B$13,2,FALSE) Assumes Sheet2 column A has list of possible selections from the DV list and column B has a list of items to return to E6 Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 13:12:01 -0700, Sylvan06 wrote: I have a drop down box in A1 with 13 different items from another sheet (same workbook). I need a formula in E6 (for example) that says (in plain english for simplicity sake). If "AB" is selected from the drop down box then display cell B2 from sheet 2, if AC is selected then display cell B3 from sheet 2, if AD is selected then dislplay cell B4 from sheet 2.....etc. If this is confusing (may have confused myself) let me know and I can try to simplify. Can anybody help me with this. Would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|