I have the following formula in column 4, row 4 of a multi row/column
spreadsheet, where I am referencing a value from one worksheet and looking
for the same value in an adjacent worksheet. It's basically a VLOOKUP
function.

=IF(ISERROR(INDEX('Daily Activity'!$A$1:$B$77,SMALL(IF('Daily
Activity'!$A$1:$A$77=$B4,ROW('Daily
Activity'!$A$1:$A$77)),ROW(1:$1)),2)),"",INDEX('Da ily
Activity'!$A$1:$B$77,SMALL(IF('Daily Activity'!$A$1:$A$77=$B4,ROW('Daily
Activity'!$A$1:$A$77)),ROW(1:$1)),2))

The function works as I want it to; however, if I copy the formula exactly
as is to say column 6, row 4, and then change the range from A1:a77 to
A81:A90, then the formula does not work. I can't figure out why. Can anyone
help?

Thanks.


--
Allan