vlookup and val by target

Copper Contributor

I'm stuck. I can get the names from sheet1 to go over to sheet (traffic) by click checkbox in userform. I can get the first instance of a vlookup to run. But, how do I get the next entry (dropping down one line) to vlookup. The names work fine; the first "traffic assignment" works fine. But phone and email do not hit for lookup. Any help is appreciated.

1 Reply

Here is the entire file. keep in mind, I wrote my first code <4 weeks ago, so it is probably not very good.