Simply remove he $ signs before the row numbers

--
Hth

Kassie Kasselman
Change xxx to hotmail


"NeedExcelHelp07" wrote:

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)