Userform to return vlookup then reference vlookup text

Hi - I am trying to input a file number (example = 11-F01234) into a userform and then have corresponding data populate in the other fields of the userform. My userform is not throwing any errors but it also is not returning the values. Can anyone see what I am doing wrong with the below code?

Reg 1 = the textbox where I am putting in the file number. Reg 2 = the lookup values.... on a sidenote - I am then going to use the return values to populate fields on a web page so will need to be able to reference them after

Please Login or Register  to view this content.

Here is an example.. I had to remove a lot of things so it may show an error but if you can get this to work then I will be able to get mine to work. The data wont start untilrow 24 like it does here... the headers will be on row 23...

Yes - sorry about that... the file numbers are in column A on this example but in C in the actual workbook. let me give this a try now, thank you!

Thank you! This is close enough to what I need (since I did not explain very well and could not provide exact workbook) - I can figure it out from here - one last question - if I need to format a cell as a date, or a time, how do I edit that specific reg# to do so?

Also, if I wanted to reference a particular one of these reg's when filling out a form online - how should I reference it? Below is an example of how I have used one in the past, with a specific column/row

IE.document.all("Document_Type").Value = ThisWorkbook.Sheets("Data").Range("e2")
Do Until IE.readyState = 4