cell copying?

[phil2006]

Hello,
Can anyone help me to copy a value from one cell to another. My work is on sheets 1 and 2. Where I have a text word with a value in the column next to it I need that value to appear on page two in the column next to the same text word when I insert it regardless of it's position in the table and how many times it is repeated.
Thanks

Phil

[Roger Govier]

Hi Phil

On sheet2 in cell B1 enter
=VLOOKUP(Sheet1!A:B,2,0)
and copy down as far as required

--
Regards

Roger Govier


"phil2006" <phil2006.290xlb_1149670310.829@excelforum-nospam.com> wrote
in message news:phil2006.290xlb_1149670310.829@excelforum-nospam.com...
>
> Hello,
> Can anyone help me to copy a value from one cell to another. My work
> is
> on sheets 1 and 2. Where I have a text word with a value in the column
> next to it I need that value to appear on page two in the column next
> to the same text word when I insert it regardless of it's position in
> the table and how many times it is repeated.
> Thanks
>
> Phil
>
>
> --
> phil2006
> ------------------------------------------------------------------------
> phil2006's Profile:
> http://www.excelforum.com/member.php...o&userid=35092
> View this thread:
> http://www.excelforum.com/showthread...hreadid=549374
>

[phil2006]

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

[Roger Govier]

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" <phil2006.2910u0_1149674402.5371@excelforum-nospam.com> wrote
in message news:phil2006.2910u0_1149674402.5371@excelforum-nospam.com...
>
> 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
>

[Roger Govier]

typo
Here not "hear"

--
Regards

Roger Govier


"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:OcCeoqhiGHA.3320@TK2MSFTNGP03.phx.gbl...
> 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" <phil2006.2910u0_1149674402.5371@excelforum-nospam.com>
> wrote in message
> news:phil2006.2910u0_1149674402.5371@excelforum-nospam.com...
>>
>> 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
>>
>
>