Hello दोस्तों… Welcome to Beyond Static 4 U…
Aaj main aapko ek super useful Excel trick dikhane wala hoon…
Ye trick hai DGET function… jo aapko help karta hai… database se exact information easily nikalne mein…
Chaliye screen par dekhte hain…
Humare paas employee data hai — Employee ID, Name, Designation… Join Date, aur Salary…
Ab maan lijiye, aapko Employee ID 1005 ki details chahiye…
Toh yahan DGET function kaam aata hai…
Formula hai:
DGET(database, field, criteria)
Database matlab poor