| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cells
On sheet1 I have the following data:
A B 111 NAME_1 222 NAME_2 333 NAME_3 444 NAME_4 .... ... On sheet2 I'd like to link certain cells so that when I write in one cell »111«, for example, I want in the cell beside to appear NAME_1. Tnx for help, stremetzky |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells
It's called VLOOKUP and I've an article on it he
http://www.officearticles.com/excel/...soft_excel.htm **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "stremetzky" wrote in message oups.com... On sheet1 I have the following data: A B 111 NAME_1 222 NAME_2 333 NAME_3 444 NAME_4 .... ... On sheet2 I'd like to link certain cells so that when I write in one cell »111«, for example, I want in the cell beside to appear NAME_1. Tnx for help, stremetzky |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells
It works! Thank you so much... stremetzky |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells
So glad I could help!
**************************** Anne Troy www.OfficeArticles.com **************************** "stremetzky" wrote in message ups.com... It works! Thank you so much... stremetzky |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
| Linking cells | Excel Discussion (Misc queries) | |||
| linking cells | Excel Worksheet Functions | |||
| Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel | |||
| Linking cells | Excel Worksheet Functions | |||
Linear Mode
