+ Reply to Thread
Results 1 to 6 of 6

Show values ​​in the list

  1. #1
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    Show values ​​in the list

    Hello all.
    I have the following situation:
    I have some values ​​in column A.
    other values ​​in column B.
    I want to be able to display a list using the values ​​in column A and values ​​in column B.
    A1-> B1, etc..
    Attach file:
    Book2.xlsx

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Show values ​​in the list

    If you mean it by concatenating the A1 and B1, try the below formula......

    =A1&" -> "&B1

    If this is not what you want, please explain what do you want exactly.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    Re: Show values ​​in the list

    I want to be able to select from a list of values ​​in column A and in a cell to display the values ​​in column B.
    If the select list is 80 - as in the attachment - then be displayed value Ø88, 9, if I select for example 350 to display the value Ø355 etc .. etc

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Show values ​​in the list

    Please find the attached sheet to see if this is what you want.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    Re: Show values ​​in the list

    sktneer thxxxxxx ..is perfect!!!

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Show values ​​in the list

    Glad to help you. Thanks for the feedback.
    If you have got the answer, please mark your thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

+ 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. Replies: 0
    Last Post: 11-27-2013, 09:11 PM
  2. Grading list of unique values​​
    By fidelski in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2013, 09:35 AM
  3. Grading list of unique values​​
    By fidelski in forum Excel General
    Replies: 1
    Last Post: 04-20-2013, 08:28 AM
  4. Replies: 7
    Last Post: 11-23-2012, 08:40 AM
  5. [SOLVED] VBA to sum values ​​based on the values ​​in column
    By young_86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 11:49 AM

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