Search help!

[demonfootball21]

I am trying to use a search feature that will match by one column(Last Name) and if it comes up with multiple matches it uses the next column(First name) to retrive info.
Example
=VLOOKUP($A2,Students!$A$2:M1599, COLUMNS(Students!$N4:N4)+12,0) is the formula I have. It is searching by last name(A2), so when it goes over to the STUDENTS! sheet it finds the first entry of that name. So if I have one Smith, I'm golden. It populates Smith's info. But if I have two Smiths, it will only give me the info of the very first person.

Thanks!!

 

[demonfootball21]

So I if I have Smith I want it to use their first name to find the info

 

[John Davis]

So I if I have Smith I want it to use their first name to find the info

Does this thread give you any ideas?

http://www.mrexcel.com/forum/showthread.php?t=568635