Vlookup in one cell and pulls data from several columns

Hi All,

This may seem a little vague, but is a way you can do a Vlookup to one column and it will pull through a number of columns?

I have attached an example to better understand what I mean.


In sheet 1 it has all the information about the person, number first name last name e.t.c

In sheet 2 it has just the employee number but they are there more than once. Is there a way that in sheet 2 that I can do a Vlookup in one cell that pulls through the rest of the information? For example if in sheet 2 column B was "Title" i would do a Vlookup in that column and it would put the rest of the information in the other columns?

Sorry for souding so stupid or not even explaining it properly but is this possible?

Excellent, Exactly what I wanted.

Cheers,
Adam