I have a Table of names and data that goes along with the names in excel on one worksheet. Another worksheet has the same names on it but they change everyday. I would like to look at the name on the sheet that changes, find the name in the table and extract the data that goes with the name to an userform textbox. I can use the lookup function in excel but I cant seem to get the lookup application function to work in vb.

Thanks
Jeremy