Vlookup to show multile values in one cell

[SPIG]

Hello all,
long time, how has everyone been? good i hope...

I need some help here please if possible Im working on a dashboard for work and want to combine a few cells together in cell b6 i have one value from a vlookup,,, VLOOKUP($A6,'11-3-14'!$H$3:$J$33,3,FALSE)&" /" and cell c6 i have the other information that i want to add as you can see with the &" /"... and the formula in c6 is VLOOKUP($A6,'11-3-14'!$H$3:$J$33,2,FALSE) My problem is i cant get the two to combine. I want the information from both cell to show in b6 together.

Any advice.
thanks

See attached if you would likeNovember_Dashboard.xlsx

[mcmahobt]

You need to add an additional "&".

Your formula in B6 would look like this (assuming you want to combine with C6):

Please Login or Register  to view this content.

[SPIG]

I tried that and for the life of me it would not work.. I kept getting a FALSE error...Thank you very much

[Pete_UK]

You can either use this in B6:

=VLOOKUP($A6,'11-3-14'!$H$3:$J$33,3,FALSE)&" / "&C6

in which case you would still have the second value in C6,, or you could do this in B6:

=VLOOKUP($A6,'11-3-14'!$H$3:$J$33,3,FALSE)&" / "&VLOOKUP($A6,'11-3-14'!$H$3:$J$33,2,FALSE)

in which case you can remove the formula from C6.

Hope this helps.

Pete

[newdoverman]

The formula is correct as written by mcmahobt.

Look very closely at the code between the two VLOOKUPS.

=VLOOKUP($A6,'11-3-14'!$H$3:$J$33,3,FALSE)&" /"&VLOOKUP($A6,'11-3-14'!$H$3:$J$33,2,FALSE)

[SPIG]

Pete, the first formula you suggest would work but i want to get rid of the excess cells so the second one you and mcmahobt have suggested is perfect. Thank you guys

[SPIG]

Thanks newdoverman