Excel Magic Trick 😱 Dropdown Se Photo Auto-Change!

Excel me sirf naam choose karo… aur photo automatic aa jaye! 🔥
Is short video me maine bataya hai kaise aap INDEX + MATCH formula aur Linked Picture use karke dynamic image display bana sakte ho.

Use Formula:

=INDEX(Sheet1!$B$2:$B$5, MATCH(Sheet1!$D$1, Sheet1!$A$2:$A$5, 0))
✔ Dropdown se name select
✔ INDEX–MATCH se correct row find
✔ Linked picture se photo auto-update
✔ Perfect for ID cards, employee lists, student records

Full Steps 👇

Names A2:A5 me type karo

Photos B2:B5 me insert karo → "Move and size with cells" ON

D1 me Data Validation → List banayo

Formulas → Name Manager → New →
Formula paste karo:
=INDEX(Sheet1!$B$2:$B$5, MATCH(Sheet1!$D$1, Sheet1!$A$2:$A$5, 0))

Picture ko copy → Paste As Linked Picture

Linked picture select karke formula bar me likho:
=SelectedPic

Ab name change karo → picture instant change! 🎉

Excel lovers ke liye perfect trick!

Like ❤️ Share ↗ Subscribe 🔔 for more Excel magic!

Видео Excel Magic Trick 😱 Dropdown Se Photo Auto-Change! канала Cyber Computer Education Centre (Dhanwant Pal)