Duane,

Thanks very much! Your formula works fine if there is only one instance
of the number in cells A1:A7. But what if there is more than one
instance of the number in the cell range? Is a variation of your
formula capable of listing all of the cell references the number appears
in? Right now, the formula as you gave me lists the first cell it finds
the number in.

Thanks,
John

duane wrote:
there may ba a more simple way but if your list is a1:a7 and you are
looking for the cell withthe value in b1

=CELL("address",OFFSET(A1,MATCH(B1,A1:A7,0)-1,0))