vlookup

[philquad]

i have to use vlookup and "concatenation" in one formula

eg vlookup xx
table array xx bbb ccc ddd eee fff
cloumn index no. 4 (is corect)

anser should be ddd, eee, fff

i have tryed vlookup xx,table xx:fff col,(4 & 5 & 6)
but it doesnt comine the 3 text strings

is there another formula i should use.

 

[duane]

=vlookup(xx,table xx,4)&vlookup(xx,table xx,5)vlookup(xx,table xx,6)