VLOOKUP 2 cells into 1

[Solidstan]

I would like to VLOOKUP a cell value and return 2 values into 1 cell. Im looking for an EASIER idea to to this.
example.

Please Login or Register  to view this content.

So these two results will be displayed side by side, in one cell.
The second result will always be an adjacent cell to the first result.
i.e. column 2 and 3.

Thanks in advance.

[Fotis1991]

Do you mean?

Please Login or Register  to view this content.

[Solidstan]

Ha yer thanks. That works.

But I was hoping to shorten it to-

Please Login or Register  to view this content.

or something simular
Because I have these to functions nested 7 Times and my formula is already huge.

But that will do unless you know of a shorter way.
Thanks loads.

[Fotis1991]

No. I can not thing something shorter but keep in your mind that vlookup-and specially using for such a small range- has no problem of slow your calculations. So maybe will be a hudge formuala but will be no other problem in the application!