Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Jim, you may want to try something like this:
http://www.officearticles.com/tutori...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com "SLLD" wrote in message .. . 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 |
#3
|
|||
|
|||
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 he http://www.contextures.com/xlFunctions02.html and another sample with instructions he 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 |
#4
|
|||
|
|||
thank you
I am just a bit new to this.. "SLLD" wrote in message .. . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional forming causing linking errors | Excel Worksheet Functions | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
linking to other worksheet | Excel Worksheet Functions | |||
Have to use cursor keys cannot use mouse in excel when linking fo. | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions |