Index
 

The problem is to create a search page that allows the user to enter a student's SIN and terieves the data from the other columsn. The problem is I am not familiar with the INDEX Function, but i have tried doing the formula and it is not working. anyways, here is the formula i have: =INDEX(table, MATCH(Input,SIN,0),MATCH(Criterion,titles,0))

Here is the Table (in a different worksheet):

Student # Last Name First Name SIN
200599035 Leung Afshine 554386021
200629527 Leung Alex 563240108
200668145 Lewis Alex 465637569
200705004 Acerbi Alexandria 311099586
200735910 Li Alice 593572927
201197201 Lee Alison 364251231
201207497 Lindsay Amanda 595878125
201227297 Liu Amankumar 203604506
201228923 Lee Ambrose 484385421
201235506 Lau Ana-Mariea 433759404
201239359 Lai Anca 435640730
201256585 Kwan Anh 512142776
201257260 Kupczynski Anna 238734027
201308022 Liu Anna 291411734
201325216 Mah Arale 439178856
201345602 Kohl Arie 460084012
201352541 Mao Arlene 569614562
201417351 Mariani Bart 269147056
201419282 Kidd Brandon 577769336
201438621 Martin Brandon 357187626
201453224 Massiah Carlos 424213315
201518182 Amin Caroline 283507081
201520113 Khona Catherine 407582879
201596626 Andrews Chi 555985721
201616168 Mattei Ching 420300594
201820380 Mayer Ching 256670754
201829241 Meyers Christine 448009858
201844927 Mohabir Chucheng 389352985
201861954 Atefi Cindy 320196785
201879428 Morales Cindy 337163943
201886217 Khan Crystal 571616786
201893726 Khazanov Crystal 332987637
201935436 Morin Darrin 356117429
201937044 Mullen David 313801318
201939362 Au Deborah 327279617
201940998 Naftolin Diana 297658157
201941087 Nava Eathcliff 585299460
201947894 Ng Emily 310533376
201966555 Nguyen Eram 232825525
201968890 Olender Erin 264013494
201970227 Kaivan Mehr Francesco 561063584
201985332 Palmieri Frank 289989280
202005908 Parnham Georgette 469256685
202012516 Baigorri Gianluca 254443248
202026607 Pickard Harminder 571670053
202026755 Bakalovski Henry 456128610
202030013 Ralhan Henry 523610782
202031128 Kaganovitz Holly 466027084
202033769 Balduzzi Hui-Wen 536528123
202039378 Ratusny Huong 527235226
202039626 Rosevear Inna 461690226
202040178 Bellofiore Jackson 344247714
202052124 Jadubir Janet 541339443
202056273 Huynh Jasmine 579204296
202057966 Roter Jason 449923795
202063311 Rovos Jean 386129419
202068948 Bhowmik Jean-Marc 261555610
202070035 Black Jennifer 422178044
202075968 Schmidt Jennifer 295101777
202079267 Bodach Joanna 279082750
202086312 Seidenfeld Jodi 556219373
202088565 Hexham John 314995118
202089761 Sfikas Jonathan 451587378
202091403 Sherriff Ka 324175536
202104313 Bradshaw Kam Fai 212475929
202127470 Braganza Karina 410636852
202127587 Brown Karmen 549058582
202128502 Halek Kar-Yuen 388871550
202141315 Buehler Kathy 392031146
202159168 Shim Kwai-Lin 222422032
202176477 Habus Lino 491307874
202200343 Bukvic Lisa 419163950
202246783 Singh Lisa 293692864
202299170 Guterman Lisane 442157202
202316099 Siu Maggie 510417412
202372134 Guaca Marie 493941864
202499200 Siu Mark 287579234
202505006 Sivanandamoorthy Martin 400196000
202539047 Buzzanca Matthew 409448559
202571974 Capobianco Mei-Jung 478834900
202576197 So Melissa 322085060
202576221 Soeiro De Andrade Melissa 481912186
202577526 Giacomini Michael 544112928
202588101 Girmay Michael 217598675
202591832 Go Michael 321121504
202602308 Gocool Michael 218825530
202606465 Geambasu Michal 370067158
202612505 Gardner Michelle 514090338
202613214 Ceccarelli Monika 565744962
202613503 Stewart Monique 265807282
202620011 Syed Nadia 577851467
202623734 Fuccio Nana 363793953
202624377 Cha Nancy 504943818
202624385 Tam Nicol 337772929
202627131 Chan Nisha 552472934
202636678 Freeman Orit 321219002
202637049 Chan Paolo 376358862
202649408 Tang Paraskevi 304915128
202656577 Chan Paul 256010544
202656908 Tse Pui 364086767
202658771 Tseng Renee 580676918
202659555 Tung Rita 512551589
202660405 Fork Robert 253696019
202661205 Uesson Robert 433143043
202661502 Fairley Rohit 382364050
202662237 Chen Rossana 481871844
202662690 Vachon Rossana 547917587
202667715 Dvorchik Roy 383161493
202668705 Vande Vooren Ryan 313558603
202669778 Cheng Sabrina 343580521
202670792 Vulich Sabrina 388834791
202680049 Wan Sandra 431013345
202681427 Cheng Sasha 266598743
202688133 Wei Selma 350786639
202693737 Wong Shaindy 360115670
202693760 Wong Shalini 380535234
202700961 Cheng Sharon 521066106
202703486 Wong Sharon 274767637
202712180 Wong Shelly 577495050
202714020 Wong Shoshana 463426573
202714293 Wong Shu 596905588
202716058 Woodward Simon 294319995
202718989 Wu Siu 201209450
202719003 Duarte Stacey 562543488
202724664 Cheong Stephanie 424131805
202725596 Yiu Stephen 282990530
202740801 Yu Subothini 534532110
202744084 Cheung Sunita 524386941
202769784 Donkor Susan 488685713
202770071 Yusuf Sze 266927016
202780245 Zaklikowski Tatiana 374759147
202815884 Zhardanovsky Te-Hsiang 594119704
202842896 Cheung Tihana 534149149
202843910 Dallal Tony 363326373
880229321 Cho Tsz 312845258
911076486 Cunningham Valerie 537810256
920236642 Craig Wai Ching 319058315
930603591 Correia William 356244994
931625387 Chou Wing 366626424
931703044 Chow Yin-Chun 322643529
933592601 Chu Yoon-Kyung 366637569
933747650 Ciobanu Zaheeda 432101604


Please help,

Thanks,
Reuben