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