ISTEXT from drop down list

[James K]

I have a drop down list in one cell and I would like the adjacent cell to return different text depending on which word is chosen from the drop down list. The list is referenced on a master sheet and the text to be returned is on the same master sheet.

[Andrew-R]

You almost certainly need a VLOOKUP.

Say, for example, your list reference is in cells A1:A20 of a sheet called 'Master' and the text you want returning is in B1:B20 of the same sheet, and your drop-down list is in cell C1 of another sheet, then:

=VLOOKUP(C1,Master!A1:B20,2,FALSE)

[James K]

Thanks,
Next issue. I want the returned text to be editable. Currently the formula shows if I double clicl in the box.

[Andrew-R]

Ah, then we need to move to the wonderful world of VBA code, rather than formulas.

Do you have an example workbook you could post?