Data Validation List add cell reference prefix
Results 1 to 2 of 2

Thread: Data Validation List add cell reference prefix
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Validation List add cell reference prefix

    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.

  2. #2
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    300
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data Validation List add cell reference prefix

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •