Do you mean within the same cell?
You could concatenate two vlookups referencing different columns.
Ex:
=VLOOKUP(E6,$I$8:$k$10,2,1)&" "&VLOOKUP(E6,$I$8:$k$10,3,1)

tj

"Ian Johnson" wrote:

Does the VLookUp function only allow you to return the
value in ONE column from the "column_index_number" in the
functions arguements?

If so, is it possible to return more than one columns
value with another function?

Many thanks
Ian.