Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    two looked up numbers side by side in one cell

    Hi Everyone
    I have a unique problem and hope someone can help me solve it
    I have a excel sheet

    I also have another sheet with different numbers 1 to 6

    I want my first sheet to look up 2 of those numbers and display them side by side in one cell

    I can do the lookup but cannot get my cell to display the 2 numbers side by side

    Any ideas

    Thank you
    Johann

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Johann,

    Try this:

    =CONCATENATE(VLOOKUP(3,Sheet2!B1:C6,1,0)," ", VLOOKUP(3,Sheet2!B1:C6,1,0))

    concat4.png

    Where the table is on sheet 2 B1:C6

    You can do this without the concatenate function as well

    =VLOOKUP(3,Sheet2!B1:C6,1,0) & " " & VLOOKUP(3,Sheet2!B1:C6,1,0)

    HTH,
    Maud
    Last edited by Maudibe; 2014-04-12 at 11:32.

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Johann,

    You can remove the spaces between the numbers with

    =CONCATENATE(VLOOKUP(3,Sheet2!B1:C6,1,0), VLOOKUP(3,Sheet2!B1:C6,1,0))
    Last edited by Maudibe; 2014-04-12 at 11:27.

Posting Permissions

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