+ Reply to Thread
Results 1 to 7 of 7

return multiple header cell values into one cell concatenated based on a cell value

Hybrid View

  1. 09-13-2016, 06:20 PM #1
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,896

    Re: return multiple header cell values into one cell concatenated based on a cell value

    Formula solution. Use Azumi's array entered formula to create helper columns (H2:K2 in attached file) which may be hidden for aesthetic purposes. Paste the following formula in F2:
    Formula: copy to clipboard 
    =IF(H2<>"",H2,"")&IF(I2<>"",", "&I2,"")&IF(J2<>"",", "&J2,"")&IF(K2<>"",", "&K2,"")
    Let me know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Return Cell Value based on Values in Multiple Columns
    By Cardan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2015, 10:20 PM
  2. Lookup and return multiple values concatenated into one cell
    By funinsum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2015, 06:26 PM
  3. [SOLVED] Value of cell based on concatenated values
    By Michael Bass in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2014, 11:10 AM
  4. Lookup multiple values concatenated into one cell without duplicates
    By Atul Maskara in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 09:33 AM
  5. [SOLVED] Match multiple substrings in a cell against a lookup table and return concatenated values
    By stevewc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2013, 10:50 AM
  6. [SOLVED] How to display multiple values concatenated in 1 cell without double entry of result value
    By jomi9501 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-19-2012, 03:07 PM
  7. Excel 2007 : Formula that will return a value based on the values in multiple cell
    By 4am in forum Excel General
    Replies: 6
    Last Post: 06-08-2010, 09:42 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1