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
Bookmarks