Index in array returning #NUM! error

I am having trouble with an index formula that returns the #NUM! error. I have attached a sample of a workbook I am using. I have payment vouchers sheets (1001, 1002). The Data sheet collects information from all the voucher sheets. From there I have individual Cost Element sheets that should pick out their cost elements from the Data sheet and transfer the corresponding info to the sheet (date, check #, Vendor, amount, etc.) In the example attached cost sheet 724 is included.

I am not very familiar with the Index formula and can't figure out what is wrong with this formula. I am hoping someone can.

Thanks

daddylonglegs:

I am doing the dance of joy!! That was just what I needed. Can you help me with one more problem?? You knew that was coming. When I copy the formula down the page, the cells that do not find anything have an error message in them. I have added the ISERROR function but when I hit Ctrl, Shift, Enter I get a message: "You've entered too many arguments for this function." Any suggestions? Here is the formula I am trying to use:

=IF(ISERROR(INDEX(Data!B$1:B$42,SMALL(IF(Data!$A$1:$A$42=$D$5&"",ROW(Data!$A$1:$A$42)),ROW(1:1))),"",INDEX(Data!B$1:B$42,SMALL(IF(Data!$A$1:$A$42=$D$5&"",ROW(Data!$A$1:$A$42)),ROW(1:1)))

Thank you

DonkeyOte:

Thank you so much. You solved all my problems!!!