# Thread: two looked up numbers side by side in one cell

1. ## 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. 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

3. 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))

#### Posting Permissions

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