Indirect Data validation List

[mohitspamz]

Hey all,
I'm trying to get an indirect data validation condition. However, the lists are ever expanding and thus i'm using the following formula to define these lists:

=OFFSET(List!$C$1,0,0,COUNTA(List!$C:$C),1)
=OFFSET(List!$D$1,0,0,COUNTA(List!$D:$D),1)

My, data validation formula in column H is:

=INDIRECT($F1:$F1)

However, because i'm using an offset formula, i get an error on the data validation.

Column F is the validation condition column which has "Own" and "Market". i got both lists under the offset function. I need to fill up Column H based on the cell value of Column F.

Any help would be great.

Thanks

Mohit

 

[RoryA]

Define a name called say MyList as referring to:
=EVALUATE(sheet1!$f$1)
and then use =MyList as the DV source.

 

[grizz]

I think you you only need to click on D and highlite entire column and name it OWN and same with column C and name it MARKET then your Data / Validation

=indirect(F1)