Add this formula to cell C4 of sheet 1. Copy it down the lookup range in
sheet 1.

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

If the formula,

B4 - refers to the value you want to find.
Sheet2!$B$3:$C$11 - refers to the lookup range on sheet 2
2 - refers to the cell offset. Excel always starts at the left side of the
lookup range. Since your range is Sheet2!$B$3:$C$11, Excel starts in column
B, finds the value, and then moves over to column C to get the value (2
columns total).

----
Regards,
John Mansfield
http://www.pdbook.com



"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