Data Validation List add cell reference prefix

scwisely

New Member
Joined
Jun 21, 2019
Messages
22
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.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Aryatect

Active Member
Joined
Jun 17, 2019
Messages
308
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,455
Messages
5,487,002
Members
407,575
Latest member
calc

This Week's Hot Topics

Top