Index(match not pulling only 2 of five records

I am using Excel 2007.

I have a database sheet (Employees) and a Lookup sheet to prevent damage to the database sheet. The old script that only pulls two names out of a max of five names. The new script only returns "#N/As.

OLD SCRIPT: =IF(F3,"","",VLOOKUP(F3,Employees!A1:G250,4,0) and thought this new formula would populate with the information I need displayed:

NEW SCRIPT:
=INDEX(Employees!$A$1:$E$250,MATCH($A1,Employees!$B$1:$B$250,0),1) =INDEX(Employees!$A$1:$E$250,MATCH($A1,Employees!$B$1:$B$250,0),2) =INDEX(Employees!$A$1:$E$250,MATCH($A1,Employees!$B$1:$B$250,0),3) =INDEX(Employees!$A$1:$E$250,MATCH($A1,Employees!$B$1:$B$250,0),4) =INDEX(Employees!$A$1:$E$250,MATCH($A1,Employees!$B$1:$B$250,0),5)

Any suggestions on how to make this work? I have attached a sample of the format I am looking for. Thanks for any guidance.

Jeversf,

Thanks for your recommendations. I see it works on your sample back. I will go and test it on the copy of my live forms to see how it performs.

I still have much to learn. I will get back to you as soon as I test it completely.

Michael

martinwilson,

Thanks for your recommendation also. I will try them both to see the difference.

Both seem to work on the sample I provided. The real test will be on the test forms.


Michael

Thank you. Your rememded changes worked 100%.

I liked your recommended changes. My database sheet changes daily, and I thought the helper feature would be to cumbersome to manage. I still like it and retain it for possible future use.

Thanks again.