M
Mac
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?
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?