I have an Excel that has 2 sheets. 1st sheet is my Form and 2nd sheet has the Data. Data sheet has 2 columns A - Code, B - Description. So What I am trying to accomplish is if my staff enters a number on the Form then excel will automatically recognize that number from the Data sheet in Column A and enter in the data from Column B in a different cell on the Form.
Solved by F. C. in 11 mins