Okay everyone, I need your help. I'm still a beginner programmer and I don't really know what to do here. I have an excel document, already created. That part is fine. On my form, I have a textbox, named tNumberTextBox. My excel document looks like this...



As you can see, I have some columns with headers. Okay, here's what my form looks like...



The textbox is the middle is my main focus here. It's an AutoComplete textbox, so as you type, it shows the values in the CustomSource. Which is fine and working just fine. However, I want to change things. I want the values in the FIRST COLUMN of my excel document to be in the CustomSource. The user will be able to add values to the excel document in another form that I have. That works fine too. So I don't know how to make it so that ALL of the cells in the "T-Numbers" column of excel is in the CustomSource for the textbox.

Also...What I want to happen is...whatever is IN the textbox when the user clicks the button, then I want it to display the data ON the FORM under the appropriate labels. All I need is the data to be in string format. So...

Code:
if (tNumberTextBox.Text = (ANYTHING IN COLUMN A1) 
{ 
polarity = (THE ROW WITH THE PROPER TEXT, POLARITY COLUMN) 
interfaceOne = (THE ROW WITH THE PROPER TEXT, INTERFACE1 COLUMN) 
interfaceTwo = (THE ROW WITH THE PROPER TEXT, INTERFACE2 COLUMN) 
notes = (THE ROW WITH THE PROPER TEXT, NOTES COLUMN) 
}
So...how can this be done. How can I check for the proper row, by using whatever is in the textbox and then set the proper cell to string format. I'm sure this is a tough task. I'm still a beginner programmer...so...if anyone is willing to devote some time into helping me and explaining everything step by step, that would be wonderful. Thank you all so much!