Search data in excel and return the result in a win form text box
I am trying to make an automation that uses a windows form and an excel file. I created a combo box with a series of items (names of some templates) and I want to make it so that when the user selects a certain item in the win form drop down menu, the robot will search for that item in excel (A column) and then copy the corresponding text (from B column) to a text box back in the windows form.
Can someone assist me with the steps I have to go through in the automation in order to be able to achieve this?
If somebody can share some sample code for this, it would be very much appreciated.