This entered with ctrl + shift & enter should give you all 3 items

=INDEX(Last_Name&" "&First_Name&" "&Student,MATCH($B$2,SIN,0))

you can switch places between the ranges

--
Regards,

Peo Sjoblom


"Lisa" wrote in message
...
Criterion
SIN 212475929
Student # =INDEX(Student,MATCH($B$2,SIN,0))
Last Name =INDEX(Last_Name,MATCH($B$2,SIN,0))
First Name =INDEX(First_Name,MATCH($B$2,SIN,0))

I have a table on another worksheet where the user will enter in the SIN #
and the other information is extracted from it. I need to lookup this
information using ONLY ONE formula. As you can see here I have 3 different
ones.

Any ideas?
Lisa