Neil

If the names entry you are making is in column A on sheet1 (Starting in A1)
and the data in Sheet2 goes from A1:D100, with the address (for example) in
column B on Sheet2.

Then in B1 on sheet 1 enter

=VLOOKUP(A1,Sheet2!$A$1:$D$100,2,FALSE)

This looks up the value in A1 on sheet1 (Name) and compares in with the
left-most column in the 'Lookup range' on sheet2 (Column A). When it finds
it, it will return the value 2 cells to the right (The name column is no.1).
The FALSE parameter, simply returns only exact matches or an error

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"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