+ Reply to Thread
Results 1 to 4 of 4

Value of cell based on concatenated values

  1. #1
    Registered User
    Join Date
    06-19-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    2

    Value of cell based on concatenated values

    I have charts that I have to update at work, and I want to make it as fast of a process as possible. Here is an example of what I want to do.

    I want to put the letter B in cell 1, then the number 23 in cell 2. I then want to concatenate those two strings, which I can do. I end up with cell 3 which says B23. I then want cell 4 to to be the value of cell B23. If the B23 in cell 3 changes to C11, I want cell 4 to be the value of cell C11.

    I would use an IF(x,x,x), but I want to to take into account the fact that it could be any cell on the whole sheet which would be one hell of a nested IF statement.

    I need to do this without macros if possible.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Value of cell based on concatenated values

    Use INDIRECT, for example if cell 1 is A1 and cell 2 is B1.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Value of cell based on concatenated values

    =INDIRECT(A1)

    where A1 contains your B23 value
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    06-19-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    2

    Re: Value of cell based on concatenated values

    Thank you both for the quick response. That is exactly what I needed!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  2. 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
  3. [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
  4. Replies: 10
    Last Post: 12-19-2012, 03:07 PM
  5. vba to Match concatenated values in concatenated columns
    By bjurick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2012, 03:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1