Vlookup to return multiple values?

[IUBball22]

is there a way to return multiple values for a lookup in the same cell?

this wouldn't ever happen, but let's say an employee ID of 2 contained the names Sally and John.

if you perform a lookup on the ID of 2 to another table containing the names, only the first value would display.

is it possible to return Sally and John in the same cell?

 

[venkat1926]

in sheet 1 data like this

Excel Workbook
	A	B	C
1	id	name	name
2	1	a	b
3	2	sally	john
4	3	c	d
Sheet1

in sheet 2 given below see the formula in B2

in that formula there is space both before and after "and"

Excel Workbook
	A	B
1	id	name
2	2	sally and john
Sheet2

if there are more than two names better to have a macro

 

[Aladin Akyurek]

is there a way to return multiple values for a lookup in the same cell?

this wouldn't ever happen, but let's say an employee ID of 2 contained the names Sally and John.

if you perform a lookup on the ID of 2 to another table containing the names, only the first value would display.

is it possible to return Sally and John in the same cell?

Care to specify the table range and the cell housing the lookup value?