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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell's contents as an index to a row ...?
Hi,
Suppose the cell link cell of the List box is in cell D15 of WS1. Now you can use the INDEX() function where the row_inout cell will be D15 of WS1. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mac" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell's contents as an index to a row ...?
??? "INDEX(array,row_num,column_num)"... Ashish, what do you call the
'row_inout cell'? Could you please use it in a real code? "Ashish Mathur" wrote: Hi, Suppose the cell link cell of the List box is in cell D15 of WS1. Now you can use the INDEX() function where the row_inout cell will be D15 of WS1. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mac" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell's contents as an index to a row ...?
Hi,
Can you give the actual range references of data on WS1 and WS2. Alternatively please mail the file at and explain the problem very clearly. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mac" wrote in message ... ??? "INDEX(array,row_num,column_num)"... Ashish, what do you call the 'row_inout cell'? Could you please use it in a real code? "Ashish Mathur" wrote: Hi, Suppose the cell link cell of the List box is in cell D15 of WS1. Now you can use the INDEX() function where the row_inout cell will be D15 of WS1. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mac" wrote in message ... 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 | |||
link to a cell's contents | 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) |