http://cjoint.com/?fbrFQwbdjf

G H
1 Product Price
2 Computer 300
3 Keyboard 15
4 Screen 100

B2:Data/Validate/Liste =$G$2:$G$8
C2:=Vlookup(B2;G2:H8;2;false)

http://cjoint.com/?fbrJUm38Gq
http://www.excelabo.net/moteurs/comp...-listescascade
http://www.excelabo.net/moteurs/comp...svalidationvba

Cordialy JB