typo
Here not "hear"

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi Phil

Hear is the response I posted to your other posting. I think it shows
exactly why you should not post to several groups!!!

I responded to your post in another ng.
Please refrain from posting to multiple groups as it wastes a lot of
time for people.
You have changed your requirement, you want column 3, not the adjacent
column so
=VLOOKUP(A1,Sheet1!A:C,3,0)


--
Regards

Roger Govier


"phil2006"
wrote in message
...

Thanks but it's not working as I want. What I need is for the value
in
column 2 of sheet 1 assigned to a name to appear in column 3 of sheet
2
whenever that name appears. For example if I have 20 names on sheet
one
I need the column 3 of sheet two to show the value corresponding to
the
name I have inputted on sheet 2. Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread:
http://www.excelforum.com/showthread...hreadid=549374