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.