Multiple formulas in a single cell referencing a drop down box.

[Sylvan06]

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.

 

[Gary''s Student]

Definitely consider a VLOOKUP() table.

 

[Gord Dibben]

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

 

[Sylvan06]

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