Try...

C4, copied down:

=INDEX(Sheet2!$C$3:$C$11,MATCH(Sheet1!B4,Sheet2!$B $3:$B$11,0))

Hope this helps!

In article ,
neilcarden wrote:

Hi all, struggling a little... I'm new to the VLookup function and need
some help..
I know this might be fairly simple - so if someone could help or
recommend a good book or resource, I'd be very grateful.


Please see example:
http://www.neilweb.co.uk/example.xls



Hi, this is what I'd like to do:
I have a predefined template on Sheet 1 which stays in the same order
and format.
I import a report into Sheet 2 which has all the above names and more.
However I only need the data from the above names to bring across from
Sheet 2 to Sheet 1.

Thanks very much in advance...
Neil