My formula screws up other reference cells...

[Jambruins]

I have the following formula entered in cells B2:B163

=INDEX(Schedule!$B$1:$B$1300,SMALL(IF(Schedule!$A$1:$A$1300=$A$1,ROW(Schedule!$A$1:$A$1300)),1))

I formulas in cells C2:C163 and for some reason they are not working. They
are coming up as #REF!. If I overwrite the formula in cell B2 and input the
value instead it works fine. Any idea why? I have been cutting and pasting
values so that might have screwed something up. Any ideas? Thanks

 

[Jambruins]

anyone have an idea? Thanks

 

[Dave O]

This will occur when your formula returns a result not expected by the
cells that reference it. You can use the Audit function to determine
which cells depend on your particular cell ("Show Dependents"), and
write your formula in such a way as to return only results that the
other cells can work with.