Data Validation List add cell reference prefix

[scwisely]

Hi All,

I have a list on a sheet named "Actions List" and I need to use a data validation list and be able to add the text from cell "E4" on the sheet to each item in the list. Essentially I am trying to use the " & " character to combine the names ... Here's my formula that is not working

=$E$4&'Actions List'!$A:$A

Any thoughts on how to add a prefix to a data validation list?

Thank You in Advance
S.

 

[Aryatect]

Hi,

This not working as Data validation might not accept array as a formula. Can you use a helper column in the "Actions List" tab where you combine in B column=$E$4&'Actions List'!$A1 and copy it down and refer to B:B in data validation.

Hope this helps.