I think that it is returning a single cell so therefore excel can assign the
single cell answer to all the cells.

whereas with heights more than one it returns an array that fills the
respective cells.

What are you trying to so and maybe somebody can provided an answer.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Uhl" wrote:

Is the Offset() function with a height of 1 supposed to return
duplicate values?

Here's an example starting at cell "A1". The first column has values
"Cat", "Dog", etc.... The second column has the array formula
"{=OFFSET($A$1,0,0,2)}".

Cat Cat
Dog Dog
Bird #N/A
Plane #N/A

That's correct. But when I change the Offset() function's HEIGHT to
"1", as in "{=OFFSET($A$1,0,0,1)}", I get...

Cat Cat
Dog Cat
Bird Cat
Plane Cat

What I really want is:

Cat Cat
Dog #N/A
Bird #N/A
Plane #N/A

What am I doing wrong?