+ Reply to Thread
Results 1 to 7 of 7

Help With Indexing two cells into one

  1. 03-18-2024, 12:24 PM #1
    GregF22
    GregF22 is offline
    Registered User
    Join Date
    01-14-2023
    Location
    Queens, NY
    MS-Off Ver
    2016
    Posts
    15

    Help With Indexing two cells into one

    Hello,

    Is there an easy way to index H7 and I7 from the "data cell" tab to the "control sheet" tab A21 in the attached example?
    I would like it to work like I did in the "control sheet" H14

    The reason I want to do this is the "data cell" tab gets rows inserted and deleted at times. which effects the order the sheets in the "control sheets" tab get printed.
    I found that if i Index them, when I insert or delete rows the control sheets will be updated correctly
    Hope i explained my issue so that it is understood.
    Thank you in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-18-2024, 12:26 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Help With Indexing two cells into one

    Are you still using Excel 2016?

    You would also need to index in H10 and H11 - what is the unique identifying aspect of that row in the data cell sheet that can be used to index these items? For that to happen, SOMETHING needs to be entered manually onto the control sheet that can be used to identifyt the row in question and then bring the items across.
    Last edited by AliGW; 03-18-2024 at 12:32 PM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 03-18-2024, 12:44 PM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Help With Indexing two cells into one

    All those merged cells. Spawn of Satan, every one of them. Nasty things. Their inventor should have been shot... just saying.

    =INDEX('Data cell'!H:H,MATCH(1,('Data cell'!B:B='Control Sheets'!H11)*('Data cell'!F:F='Control Sheets'!H10),0))&" "&
    INDEX('Data cell'!I:I,MATCH(1,('Data cell'!B:B='Control Sheets'!H11)*('Data cell'!F:F='Control Sheets'!H10),0))
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  4. 03-18-2024, 12:47 PM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Help With Indexing two cells into one

    Ah 2016. One tweak.

    =INDEX('Data cell'!H:H,MATCH(1,INDEX(('Data cell'!B:B='Control Sheets'!H11)*('Data cell'!F:F='Control Sheets'!H10),0),0))&" "&
    INDEX('Data cell'!I:I,MATCH(1,INDEX(('Data cell'!B:B='Control Sheets'!H11)*('Data cell'!F:F='Control Sheets'!H10),0),0))

    The previous version would have been an array formula, needing CTRL-SHIFT-ENTER. The one above will work fine with just Enter.
    Reply With QuoteRegister To Reply
  5. 03-19-2024, 10:08 AM #5
    GregF22
    GregF22 is offline
    Registered User
    Join Date
    01-14-2023
    Location
    Queens, NY
    MS-Off Ver
    2016
    Posts
    15

    Re: Help With Indexing two cells into one

    Much Thanks to Glenn & Aligw for your help. It works, but I had no idea it was so involved. I will have to come up with an easier way instead of inserting this formula all over the spreadsheet.
    Reply With QuoteRegister To Reply
  6. 03-19-2024, 10:14 AM #6
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Help With Indexing two cells into one

    Another method,
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-19-2024, 11:01 AM #7
    DJunqueira
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Help With Indexing two cells into one

    I think you could also do it with mail merge in Word and Excel.
    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. [SOLVED] Multiple indexing from cells
    By kevo1588 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-16-2019, 06:55 AM
  2. Indexing and matching multiple cells to one
    By wadeingforgodot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2015, 03:04 PM
  3. Indexing Cells Sequentially When Dragging Block of Cells For Template
    By meesterg in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-26-2014, 10:57 AM
  4. Indexing and matching cells across two sheets
    By Rebecca Gillon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-27-2013, 11:18 AM
  5. [SOLVED] indexing data from other cells into a list
    By will2k in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2012, 11:51 AM
  6. [SOLVED] Indexing with merged cells in the Array
    By smls in forum Excel General
    Replies: 3
    Last Post: 05-21-2012, 10:15 AM
  7. [SOLVED] Indexing Referenced Cells
    By ForMyACDs in forum Excel General
    Replies: 0
    Last Post: 02-23-2006, 05:15 PM

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