In C4,

=VLOOKUP(B4,Sheet2!$B$3:$C$11,2,FALSE)

then copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"neilcarden" wrote in message
...

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


--
neilcarden