about uscontact usnewsthe teamcareersresourcessite map
   
 
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