Pourquoi il ne faut pas utiliser la fonction RECHERCHEV.
Excel in the Brain
@excelinthebrainAbout
Tutoriels Excel avancés pour résoudre vos problèmes par des vidéos simples, rapides et efficaces. N'hésitez pas à poser vos questions dans l'espace commentaire, nous aurons plaisir à vous répondre !
Latest Posts
No results found. Try different keywords.
Video Description
Nous n'aimons pas la fonction RECHERCHEV, mais pourquoi ? Trois inconvénients majeurs : 1. Manque de flexibilité 2. Mauvaise lisibilité 3. Problèmes de fiabilité Nous allons donc voir ensemble les deux alternatives (fonctions RECHERCHEX et INDEX+EQUIV) Lien pour accéder au fichier Excel de la vidéo : https://1drv.ms/x/s!AjUAKMcL5Jr6gbZQ0rOE1elsj4B5sA?e=HkhIWm https://www.instagram.com/excelinthebrain/ https://www.linkedin.com/in/mathias-decourt/ 00:00 RECHERCHEV 00:44 Manque de flexibilité 01:02 Mauvaise lisibilité 01:34 Problèmes de fiabilité 02:03 1ère alternative : RECHERCHEX 03:19 2ème alternative : INDEX+EQUIV
Upgrade Your Gear Protection
AI-recommended products based on this video
Ulefone Note 20 Pro Unlocked Smartphone, Android 14 OS 256GB ROM 1TB Extension, 6.75” HD+ 90Hz Screen 6000mAh Battery Cell Phone, 50MP Main Camera, 4G Dual SIM Phone, Widevine L1 Certified - White
CORSAIR MP700 PRO 4TB M.2 PCIe Gen5 x4 NVMe 2.0 SSD – M.2 2280 – Up to 12,400MB/sec Sequential Read – High-Density TLC NAND – Black
![Samsung 9100 PRO Series - 4TB PCIe 5.0 x4, NVMe 2.0, M.2 Internal SSD, Up to 14,800MB/s, Fast Speed, Thermal Contorl, MZ-VAP4T0B/AM [Canada Version]](https://m.media-amazon.com/images/I/71qygJIcKnL._AC_UL960_FMwebp_QL65_.jpg)
Samsung 9100 PRO Series - 4TB PCIe 5.0 x4, NVMe 2.0, M.2 Internal SSD, Up to 14,800MB/s, Fast Speed, Thermal Contorl, MZ-VAP4T0B/AM [Canada Version]
![[New] RayNeo Air 3s Pro AR/XR Glasses - 201'' 1200 Nits 120Hz HueView 2.0 Video Display, Smart Gaming Glasses for iPhone 16,15/Android/Mac/Switch 2/PS5/SteamDeck - Next-Gen Personal Theater](https://m.media-amazon.com/images/I/61ikVEnR51L._AC_UL960_FMwebp_QL65_.jpg)
[New] RayNeo Air 3s Pro AR/XR Glasses - 201'' 1200 Nits 120Hz HueView 2.0 Video Display, Smart Gaming Glasses for iPhone 16,15/Android/Mac/Switch 2/PS5/SteamDeck - Next-Gen Personal Theater
Mini Crossbody Chest Bag - Travel Essentials, Water Resistant Fanny Pack Sling Shoulder,Running Belt Hiking Daypacks for Phone,Sport,Birthday Gift for Him Her Men Boyfriend Husband
OSOCE RFID Mens Sling Bag, Anti-theft Crossbody Shoulder Bag Travel Cycling Sport Hiking Bags for Men Women Casual Daypack(2.0Black-S)
NICGID Sling Bags, Chest Shoulder Backpacks Crossbody Purse Outdoor Chest Bag Travel Backpack for Men Women
RAINSMORE Large Sling Bag for Men Lightweight Waterproof Crossbody Bag Travel Hiking Bag Chest Bag Sling Backpack for Cycling Sport
ESR for iPhone 16 Pro Max Case, Camera Control Capture Button, Compatible with MagSafe, Shockproof Military-Grade Protection, Phone Case for iPhone 16 Pro Max, Classic Hybrid Case(HaloLock), Clear
ESR for iPhone 16 Pro Case, Camera Control, Compatible with MagSafe, Shockproof Military-Grade Protection, Magnetic Phone Case for iPhone 16 Pro, Classic Hybrid Case (HaloLock), Clear
INGIDO for iPhone 16 Pro Case, Liquid Silicone Case with Camera Protection Soft Gel Rubber Cover with Microfiber Lining Shockproof Protective Phone Case for iPhone 16 Pro 6.3", Stone
TOCOL Magnetic for iPhone 15 Case, Upgraded Full Camera Protection, Fit for MagSafe, Rugged Phone Case for iPhone 15 6.1 Inch, Drop Protection, Anti-Scratch, Black Global Recycled Standard
Canvas Sling Bag Small Crossbody Backpack Hiking Daypack Rucksack for Men Women Outdoor Cycling Travel
FuninCrea Mens Sling Bag, Oxford Chest Bag Shoulder Bag with Adjustable Shoulder Straps
G4Free Sling Bag RFID Blocking Crossbody Sling Backpack Small Shoulder Chest Bag Daypack with Earphone Hole Men Women Hiking
