linking between workbooks

[hartsojb]

I need to find out when using a Match formula if its possible and if s
how to reference multiple sheets within a seperate workbook. This i
formula i use currently to link to a single sheet.

=IF(AX17=0,0,(+MATCH(AX17,'C:\WINDOWS\Desktop\[YARNCOST.XLS]SHEET1'!$B$21:$B$391,0)-MATCH(AX17,'C:\WINDOWS\Desktop\[YARNCOST.XLS]SHEET1'!$B$21:$B$391,0)

 

[Jonathan Rynd]

I need to find out when using a Match formula if its possible and if so

if *what* is possible? Please be more specific. What are you trying to
do? Describe the result you want to happen.

how to reference multiple sheets within a seperate workbook.

In what context do you want to reference multiple sheets? Can it be
accomplished by just several function calls?