hi,

how do i remove the #N/A results from this formula?

=INDEX('c:\[Reporting
10-01-12.xls]Sheet2'!$I$2:$I$1000,MATCH($H$1,'c:\[Reporting
10-01-12.xls]Sheet2'!$B$2:$B$1000,0))

thank you for your help