I am trying to use offset in a formula to copy the contents of a named range
to my working arae.

I have several of these named ranges with several rows/colmns in each.

i have already used formuals with IF(AND( condition to bring up lists thaare
dependent on the value selected in other list.

I have tried various combinations of the formula below, but I keep getting a
value error in the cell with the formula in it. I suspect that it does not
realize that I actually do not want anything in the formula cell. I just
want the contents of the name range to appear being at the far left of the
current row or next row down and fill in the rows and cells downward with the
cotnets of the named rang.


Formula I have been using is various combination of:
=IF(AND(A7=W26,A13=K13),name_of_range offset(1,-4,1,1)

Most likely I am not putting the offset in the right location, as all I get
is the value error in the formula cell and nothing where I wanted the
contents of the range.

Perhap a forms might be better but ii wolud still have to call up the
correct form based on the combination of selected items from 4-6 lists.

Any suggestions wolud be appreciated.

Thanks
Steve

hi
and fill in the rows and cells downward with the
cotnets of the named rang.

formulas return values to the cell in which they reside. they cannot put
values in other cells.

regards
FSt1

"Steve" wrote:

I am trying to use offset in a formula to copy the contents of a named range
to my working arae.

I have several of these named ranges with several rows/colmns in each.

i have already used formuals with IF(AND( condition to bring up lists thaare
dependent on the value selected in other list.

I have tried various combinations of the formula below, but I keep getting a
value error in the cell with the formula in it. I suspect that it does not
realize that I actually do not want anything in the formula cell. I just
want the contents of the name range to appear being at the far left of the
current row or next row down and fill in the rows and cells downward with the
cotnets of the named rang.


Formula I have been using is various combination of:
=IF(AND(A7=W26,A13=K13),name_of_range offset(1,-4,1,1)

Most likely I am not putting the offset in the right location, as all I get
is the value error in the formula cell and nothing where I wanted the
contents of the range.

Perhap a forms might be better but ii wolud still have to call up the
correct form based on the combination of selected items from 4-6 lists.

Any suggestions wolud be appreciated.

Thanks
Steve