| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell's contents as an index to a row ... ?
Hello group,
assume two worksheets, named e.g. WS1 and WS2; on WS1 I have a listbox filled with values 1 through 10. Now, if I make a selection, I want to use that value as an index to the corresponding row of WS2, to acces its columns. E.g. if I select a 2, I'd be reading columns of row 2 of WS2. I hope my explanation is not too confusing.:-) Which formula should I use for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell's contents as an index to a row ...? | Excel Worksheet Functions | |||
| Using cell's contents as an index to a row ... ? | Excel Worksheet Functions | |||
| link to a cell's contents | Excel Worksheet Functions | |||
| link to a cell's contents | Excel Worksheet Functions | |||
| Rotate a box with a cell's contents | Excel Discussion (Misc queries) | |||
Linear Mode
