Lookup tables converted to userform with VBA

Hi
I have created some tables and used the lookup function to extract information. You enter the condition rating (1,2,0r 3) into table 1 column 2, and the result will appear in table 1 column 3. I would like to create a userform with the use of labels and textboxes extract the info onto the form. I have attached the file and hope someone would kindly put me in the right direction.

thanks in anticipation.