You can do it with INDEX/MATCH like so

=INDEX(Sheet2!A1:A1000,MATCH(B1&C1,Sheet2!B1:B1000 &Sheet2!C1:C1000,0))

obviously adjust the ranges to suit your data

--
HTH

Bob Phillips

"SL" wrote in message
...
I am using two spreadsheets. Both spreadsheets have last name and first
names of students from our school. I am trying to lookup the student
numbers
from one spreadsheet and populate to the other. I can do it just fine
except
when there are duplicate last names. Does anyone know how to lookup more
than just one column on duplicate last names. Example, Williams (last
name)
tons of them, I need Excel to look at Williams and first name (Jane)
before
returning the student number.

Thanks. SL