can i use the lookup function on a merged cell?
D Debra Dalgleish Jul 16, 2006 #2 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?
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?
D David McRitchie Jul 16, 2006 #3 The address of the merged cells is the address of the upper left cell of the merged cells.