linking between workbooks

  • Thread starter Thread starter hartsojb
  • Start date Start date
H

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)
 
I need to find out when using a Match formula if its possible and if so
Click to expand...

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.
Click to expand...

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