I have two excel worksheets, both with Names entered in 2 columns: Last Name and First Name. On the second worksheet, I want to look up the name on the first worksheet and automatically populate one of the other columns.

The difficulty comes in that my first worksheet has so many names, it's likely that more than one person will have the same last name (that's how it's sorted). Is there anyway for VLOOKUP to lookup 2 columns and then populate with the third? See picture below, that might explain better. Thank you!