|
|
|
|
|
|
|
|
|
question from flix |
|
question asked by |
flix |
date asked |
24 June 2003 |
subject |
excel columna lookup |
description |
hi,
if i have something similiar to the following table layout in excel:
x y z
1 2 3
4 5 6
7 8 9
i want a user to be able to just type in the column id, ie x,y,or z and then using some formula the spreasheet will create a copy of the information in the column beneath it. ie if i typed z, it would put the 3,6,9 beneath it.
note, that the user input/output would be on another sheet, and that the table would be quite a lot bigger.
any thoughts are appreciated.
felix |
|
Microsoft VBScript runtime error '800a01f4'
Variable is undefined: 'sUserName'
/support/showanswer.asp, line 305 | | | |