Need Help with Vlookup and multiple columns and sheets

[Boronut85]

Hello! 1st time poster so I hope you all can help. 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.

 

[Boronut85]

I did try to create a table in Sheet 2 (Data) and then do a drop down list in Sheet 1 (Form) with a vlookup but I couldnt get that to work.

 

[Boronut85]

Attached 2 pics for reference

https://ibb.co/gMoEon

https://ibb.co/gCKyES

 

[Jason Brown]

How is Vlookup not working?
=VLOOKUP(F1,Sheet2!A1:B14,2,FALSE)

I used F1 on sheet 1 as where the # would be entered.