I am still very much a novice but I have used the INDEX and MATCH functions before and got them to work successfully but this one eludes me should I be using a different formula for this to work.

The formula will be in my main worksheet, to run down 10,000 rows and to pull information from each employee's record ie: Name, Dates etc daily instances from each employee.

This formula works with individual worksheets

=IF(ISNA(INDEX(BloggsA!A:K,MATCH(Serial_No,BloggsA!I:I,0),1))," ",INDEX(BloggsA!A:K,MATCH(Serial_No,BloggsA!I:I,0),1))

this pulls Name ie: ARTHUR BLOGGS

=IF(ISNA(INDEX(BloggsA!A:K,MATCH(Serial_No,BloggsA!I:I,0),2))," ",INDEX(BloggsA!A:K,MATCH(Serial_No,BloggsA!I:I,0),2))

this pulls Date ie: 29/10/2014

and so on, if there is no match the cell will be blank. In my main worksheet “Schedule” I have a Named Range Serial_No and in all the employee's worksheets I have in a column a dropdown list “Serial_No” by selecting a Serial_No the information from that row in the employee's sheet will populate the row with the matching number in the main worksheet. There is 36 sheets with each employees record, in a separate worksheet “Data” I have created a named range called “SheetList” and this is the formula that I tried with variations that I cannot get to work.

=IF(ISNA(INDEX("SheetList!A:K",MATCH(Serial_No,"SheetList!I:I",0),1))," ",INDEX("SheetList!A:K",MATCH(Serial_No,"SheetList!I:I",0),1))

Can anyone explain where I am going wrong I hope this makes sense.