Excel tip to get data and search from a database

Excel tip to get data and search from a database.

#excel #exceltips #exceltricks

[Iamyourboo]

The first thing my instructor did in my database class is have us open Excel, then close it and chant "Excel is not a database"

[sahralsahri]

👍🌟🌟🌟😊
هذا الذي كان نبحث عنه من زمان لخصتي
كل المواضيع انا احييك على هذا الابداع والتفوق والامتياز والشرح الواضح لك كل الشكر والتقدير 💖💖💖

[Krikkette]

OMGoodgosh... I'm finally about to learn how to use Excel. 🙌🏽

[Alf_Alpha]

Can you make drop downs for the headings in row 2?

[Nasirnawaz]

Amazing. Wow.... But can we use this "Dget" formula with index? Or match??

[Flylikea]

Honestly, I love the various ways to build searchable lists in excel but sometimes access is better especially if you build a "local" db.

[skip]

What if I have different sheets? Will this still allow me to search through all of them or do you suggest power query for something like that?

[ramdsiva]

Alternatively i have been doing it with vloovkup and match function

[Khunryijduy]

Popcom 🎉❤🎉 silençe you hopland 🎉❤❤❤❤❤❤❤🎉