http://cjoint.com/?gDvlrMsErZ

=IF(Row()<=CountA(champ1),INDEX(champ1,LIGNE()),IN DEX(champ2;Row()-Counta(champ1)))

Cordialy JB


Ed a écrit :

Hello, I have 2 different "Lists" with a "Name" defined to each, and I would
like to use them both on a Data Validation but it seems it is not as simple
as =AND(NAME1,NAME2). It gives me a error in that way, any ideas to be able
to use both?

,thanks