Re: index / match function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <Lisa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:02B5168C-7B50-4254-973B-32EF65C737C9@xxxxxxxxxxxxxxxx
> 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 work*** 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


.

Quantcast