Just another failed attempt on this one.

=OFFSET(CELL("address",OFFSET(A1,MATCH(SMALL(SUMRN GE,2),$AO$3:$EA$3,0)-1,0))
,2,2)

Still looking for help on this...

Thanks

"AD108" wrote in message
...
I am trying to reference a cell offset from another cell in the sheet I am
working on. The formula below is generating an error. The named range
"SUMRNGE" is a set of non contiguous cells.

Any ideas?

Thanks in advance.

=OFFSET(SMALL(SUMRNGE,2),-(ROW(ED3))+1,2)

--
Remove 7 numbers to email
AD108