Dynamic list for data validation

[Ufoo]

Hello excel gurus,

I like to try different options. I have designed this formula for dynamic list for data validation: B3:INDEX($B$3:$B$28,MATCH(LOOKUP(2,1/($B$3:$B$28<>""),$B$3:$B$28),$B$3:$B$28,0)).

The formula calculated perfectly, but was rejected in the data validation menu; with the message you may not use reference operators or any constant for data validation criteria.

1) Any ideas on this problem please?
2) Any ideas on the formula please? Thanks

 

[bosco_yip]

Change it to :

=$B$3:INDEX($B$3:$B$28,MATCH("zzz",$B$3:$B$28))

Regards

 

[Ufoo]

Change it to :

=$B$3:INDEX($B$3:$B$28,MATCH("zzz",$B$3:$B$28))

Regards

Thanks. But this formula leaves spaces at the end. Any ideas somebody?

 

[bosco_yip]

Thanks. But this formula leaves spaces at the end. Any ideas somebody?

Then, try this........

=$B$3:INDEX($B$3:$B$28,MATCH("*",$B$3:$B$28,-1))

Regards

 

[bines53]

Hi ,

If you can upload a file?

David

 

[Basavaraj K H]

is this your searching, pls refer below link

http://forum.chandoo.org/threads/re...tion-drop-down-depend-cell.24096/#post-145296