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

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" wrote
in message ...

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

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

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=54937

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

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