Hey everyone...I'm having a serious brain fart, and can't seem to figur
out how to do this for some reason...I have a form w/ a textbox, an
when someone enters a number (ex. 123) in the textbox, I need it t
search for that number in all of "Info_Sheet!A1:A500" and then put th
text in the following B cell into label1 on the form.

Basically, I'm creating a LookUp form, but I can't figure out what I'
missing...any help is greatly appreciated..

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=38886