Hey everyone...I'm having a serious brain fart, and can't seem to figure out how to do this for some reason...I have a form w/ a textbox, and when someone enters a number (ex. 123) in the textbox, I need it to search for that number in all of "Info_Sheet!A1:A500" and then put the 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'm missing...any help is greatly appreciated...