You actually need more help than just the address incrementing.

Your formula will only look at the first value, in column A, for the comparison. You need to use

=IF(SUMPRODUCT(($A2:$G2='[worksheetname.xls]John Brown!$A2:$G2)*1)=7,'[worksheetname.xls]John
Brown!$H2,FALSE)

to compare all seven values in column A through G.

HTH,
Bernie
MS Excel MVP


"NeedExcelHelp07" wrote in message
...
Below is the formula I'm using to for one worksheet to match data with a
worksheet in another workbook, if data matches it references to a cell on
that row, if it doesn't it returns false. On the master file when I fill the
below formula down on the first A2:G2 increases while the others stay the
same. How can I fix this so that they all increase when I fill down?

Thanks

=IF($A2:$G2='[worksheetname.xls]John Brown!$A$2:$G$2,'[worksheetname- John
Brown-COPY.xls]John Brown!$H$2,FALSE)