thanks for the assistance. I did get the formula below to work.
--
Allan


"Bob Phillips" wrote:

See if this version is amendable

=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)-MIN(ROW('Daily
Activity'!$A$1:$A$77))+1),ROW(1:$1)),2)),"",
INDEX('Daily Activity'!$A$1:$B$77,SMALL(IF('Daily
Activity'!$A$1:$A$77=$B4,ROW('Daily Activity'!$A$1:$A$77)-MIN(ROW('Daily
Activity'!$A$1:$A$77))+1),ROW(1:$1)),2))

--

HTH

Bob

"Flipper" wrote in message
...
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


.