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.

Hi, Based on a slightly shorter version of your formula in C4:
=OFFSET(E$1,MATCH(A4,E$1:E$30,0)+MATCH(B4,E$4:E$6,0),1)
the code in the userform for the textbox1_change event should be:

Please Login or Register  to view this content.

and the same for textboxes 7-10 change events., dependant on label 1-4 and textbox 1-4.

Thanks, works a treat, could i use spin buttons limiting numbers to 1,2 3

Don't see why not, you would need to put something like:

Please Login or Register  to view this content.

Thanks, it works very well.