sheet variable
This returns "True" but not the value.
"Dave Peterson" wrote:
maybe...
=OFFSET(indirect("'"&d9&"'!C6"),COUNTA(indirect("' "&d9&"!C6:C364"))-6,-1)
wagz wrote:
I am looking for a way to use a list value from a data validation (cell D9)
to use as a value in =OFFSET(Merry!C6,COUNTA(Merry!C6:C364)-6,-1) So Merry
would be removed and the variable put in it's place. Each time I reference
the cell D9 I get a #VALUE! error.
Any help would be appriciated.
--
Dave Peterson
.
|