You should be able to return data from a merged cell. Can you give an
example of what you're trying to do, and what problem you're having?

wrote:
can i use the lookup function on a merged cell?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html