userform, label text display value depends on user input

Hi everyone, i'm a newbie in VBA and i appreciate any help that i can get! i'm creating a userform and in one of the text box user would enter their predefine ID (somewhere on the excel sheet). base on their input ID i would like the label underneath the text box to display their name. (which is also predefine on the excel sheet. would i be using the "Index & Match" function? if so, how would i write this in my code? Thank you very much for your help!!!

Dave

ZZZ- Names and IDs.xls

Dave,

I posted an alternative method of performing your application (see linked attachment above). Take a look at the workbook and see if this can suit your needs. I chose a combo box instead of a textbox for ID entry.

Let me know if you can use this.