Hello
I have the following formula
=VLOOKUP(C3,N4:T15,3)&VLOOKUP(C3,N4:T15,4)
What I want to achieve it is for the two parts of the Vlookup to be separated by a single line......i.e. and Enter on the key board.
For example, instead of the result being
Hello and welcome to this topic: Item number 1 doing what we can.
it would appear as
Hello and welcome to this topic:
Item number 1 doing what we can.
I have the following formula
=VLOOKUP(C3,N4:T15,3)&VLOOKUP(C3,N4:T15,4)
What I want to achieve it is for the two parts of the Vlookup to be separated by a single line......i.e. and Enter on the key board.
For example, instead of the result being
Hello and welcome to this topic: Item number 1 doing what we can.
it would appear as
Hello and welcome to this topic:
Item number 1 doing what we can.