linking

I have a spreadsheet with numbers in left column
Words in right one
when I put a number in the 1st colum of a linked sheet , I want the words to
be transfered to the right one
TIA
Jim

Jim, you may want to try something like this:
http://www.officearticles.com/tutori...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"SLLD" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet with numbers in left column
> Words in right one
> when I put a number in the 1st colum of a linked sheet , I want the words
to
> be transfered to the right one
> TIA
> Jim
>
>

You can use a VLookup formula to return the words that match the number
you've entered. There's information on VLookup in Excel's Help, and
instructions and examples here:

http://www.contextures.com/xlFunctions02.html

and another sample with instructions here:

http://www.contextures.com/xlOrderForm01.html

SLLD wrote:
> I have a spreadsheet with numbers in left column
> Words in right one
> when I put a number in the 1st colum of a linked sheet , I want the words to
> be transfered to the right one


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

thank you
I am just a bit new to this..

"SLLD" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet with numbers in left column
> Words in right one
> when I put a number in the 1st colum of a linked sheet , I want the words
> to be transfered to the right one
> TIA
> Jim
>
>