How to Search Data from database in Excel | Search Box in Excel in Hindi

How to Search Data from database in Excel | Search Box in Excel in Hindi
In this video you will learn how to create a search box to search emplayee data from a large database in Microsoft Excel. This can be done by using a single and very easy function and no VBA is required.
✅For more videos please subscribe our channel: / powerexbyjitendra
Download our file:
==============================
docs.google.co...
==============================
Related Videos:
How to use VLOOKUP with MATCH Function in Excel
• How to use VLOOKUP wit...
----------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#searchbox
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexby...
Contact Us:
Instagram: ...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

[@giftsbynaudy6082]

Amazing video for all who wants to learn Excel all imp formulas covered thanks

[@PowerExbyJitendra]

Thanks

[@shahqasim8513]

Hi Dear Sir ! I liked urs videos very much , easily to understand , i request you , to kindly make a videos on MART (POS) system including barcode scanner. THANKS

[@ta20111996]

Excellent and very useful! thank you so much.

[@PowerExbyJitendra]

Thanks

[@opgamerhacker2780]

Bahut hi achaa aur sir aap ek data entry type prog bannane wale the jis mai new add edit search delete aisa data sir kab bataon ge

[@asimsiddiq475]

sir, you made too good.

[@PowerExbyJitendra]

Thanks

[@MOVIESHUB96k]

This search box is so simple❤ Sir, this search box convert in userfrom please

[@MeenuRajput-d56]

👍👍👍👍

[@PowerExbyJitendra]

Thanks a lot

[@Jkstory288]

Sir maine school fee alag alag clas ki ek file me different sheet per banai hai or un sabhi ke liye alag alag search box bnana chahta hun per ek file me ek search box ban gya par doosra search box Q nahi ban rha hai new sheet per same file hai ya ek file me ek search box banta hai please reoly me

[@UmeshBajaloor]

I want as it is in google sheet

[@akshayakumarswain4606]

IF MY DATABASE FIRST ROW VALUE IN NUMERIC SO WHAT TO DO

[@PowerExbyJitendra]

No issue

[@fatimazafariqbal-f9d]

formula shows error

[@PowerExbyJitendra]

Please insert your formula carefully 🙏

[@Bezubanpyar]

Aapka number mil shakta hai

[@Bezubanpyar]

Please aapka number chayiye mere ko aek aesa aek database ae from banana hai...

[@sayadniaz7315]

Number main search nahi ho raha hai. First column main consumer Number hai and uska combo box ho Gaya but search nahi ho raha hai

[@anushri_Baby2522]

Same here

[@tanmaypandya1102]

Same here, पहले तो function ही बड़ा दिखा रहा है और बाद में NA error दे रहा है

[@sajidbpl1]

listfillrange in developer tab not showing for excel 2016

[@sagar_6221]

Sir muje error aa raha he plzz bohot arjunt he mene din bhr try kiya firbhi nahi hua. Pahili bar kiya tha to ho gaya tha ab nahi ho raha he. Mere list me 1st cell me namber he or 2 cell me name he or muje esa hi chaiye

[@amitgirdhar3882]

If I add one more entry in Database, will it add in Popup search box? If not, then how can I add the one more entry?

[@KiyaniPlateOfFlavour]

I have same question how about the multiple repeated entry ?

[@clearmind8204]

Would you please make a video on " how to enter,search, edit and delete in one dashboard? " Thanks.

[@SharmilaDharane]

Sirji agar hum name, phone, name se search karna chahe to kar sakte hai ?

[@mysumon007]

If added more entries in my database what will be happening? Please reply...🙏🙏🙏

[@najamatiq]

Error: in Linked cell reference. The number in this is formatted as text or preceded by an apostrophe.

[@raymartnicolas]

Hi can make an templates for shipment tracking hehe. Thank you

[@sdewal0205]

Sir if there is 2 or more than 2 data from one name then what will the search box show

[@mamunbahadur7508]

hello.... I am Md Mamunur Rashid from Bangladesh. I saw your video in youtube about creating search box in excel sheet with vlookup effect. But I have facing problem when i fixed data by pressing F4.It’s not working for me.... Can you pls help me in this matter. I really grateful to you for your support...

[@PowerExbyJitendra]

I think function keys are not activated in your system. If you use function keys with FN key these will work. Thanks for watching

[@sanjisagor]

Sir may apche bat korna chah ti hu

[@pratapkeshavpawar9689]

I'm having windows 7 I attended yours using search 🔍 but on entering formula IF non active please 🙏 guide

[@palllavi123]

How to repeat the same name

[@arifatrushda6816]

Thanks for the good information. Please share what to do for delete from database without vba

[@jewelrana571]

sir app goat fram ki data software banaie.I'm Bangladeshi But in to saudi arab.

[@PowerExbyJitendra]

Ok I will try

[@cbcoksa8626]

thanks for the video, i face a problem, if we have employees with the same name more than 1, we are not getting data....?

[@ARKPalthink]

Website k database s kese connect kare excel kp

[@anvarsadiqali1514]

Thanks super ❤, if I require 2 search how will do, ( example Brand and MRP) for net landing caliculation

[@seelanxavier1864]

Hi Sir, will this vlookup function works if the cells are merged. Plz let me know. i have been trying this formula the whole day

[@PowerExbyJitendra]

Yes it works. Any issue please send your excel file to me on my mail. [e-mail]

[@seelanxavier1864]

@@PowerExbyJitendra thank you for your responce, as a teacher you are a great person.

[@AmjadGraphicsDesigner]

Dear How will we do if we add more student name of this ?

[@PowerExbyJitendra]

Please convert database in table range then name of the students will add automatically

[@HoneyGymnastt]

Sir Yaha Pr Vlookup Ke Sath Row Ka Use Karke Bhi Drack Down Kr Skte hai Na

[@PowerExbyJitendra]

Yes sahi bataya apne

[@pappu_firozabadi]

में आपके वीडियो देख कर एक्सेल मास्टर बन गया हूं

[@PowerExbyJitendra]

ये मेरे लिए सम्मान की बात है

[@pachorimobile1830]

Hii

[@gyansinghtransport711]

Showing error

[@dosh_digonta]

Thanks for your video. But It's not working. Again & Again I want to do this type of work, this showing me error.

[@PowerExbyJitendra]

Kindly send me your sheet on mail: [e-mail]

[@dosh_digonta]

I was sent my excel sheet through another gmail.

[@PowerExbyJitendra]

Ok I send it after correction

[@dosh_digonta]

Ok, Thank you. I am waiting for your reply.

[@SocialMediatalkswithme]

Sir! Search wala data agar small termal printer par print krna to ous ka bta dy?

[@ahmedjatt4876]

showing erorr

[@grijalvaescobedo158]

Excelente buscador con textbox muy buena presentación gracias por compartirlo saludos 🇲🇽👏👌👌🤝

[@PowerExbyJitendra]

Thank you so much

[@iroshanakumarasiri8287]

Thank you bro ❤

[@PowerExbyJitendra]

@@iroshanakumarasiri8287 welcome

[@stevedhiwar]

एकदम easy method बताया आपने क्या यह search method macro database sheet में हम बना सकते

[@PowerExbyJitendra]

Thanks a lot

[@malli7979]

Well explained,. I am from AP

[@PowerExbyJitendra]

Welcome to our channel

[@ARKPalthink]

Nice 🙂🙂

[@SajidKhan-fh5cc]

Thank you so much sir your videos are very informative❤

[@PowerExbyJitendra]

Welcome

[@PlaywithMaths]

Excellent Sir !

[@PowerExbyJitendra]

Thanks

[@Akash20mondal02]

Showing error

[@syedhussain3136]

Thank you brother you helped me a lot!

[@PowerExbyJitendra]

@@syedhussain3136 🙏

[@sksundarray5806]

This formula is not working

[@PowerExbyJitendra]

It will definitely work.

[@bsp4449]

❤❤ Very useful video❤❤

[@PowerExbyJitendra]

Thanks 🙏

[@gauravjangid-jx6fv]

Superb ❤️😊

[@PowerExbyJitendra]

Thanks

[@digitala1vlog]

Bahut Achha laga❤🇳🇵🇳🇵

[@PowerExbyJitendra]

Thanks a lot

[@prakashrewale9776]

नमस्कार 🙏 एकदम सटीक और बेहतरीन डायनॅमिक सर्च बॉक्स बन गया है। बनाने में मजा आ गया। आपका धन्यवाद धन्यवाद धन्यवाद

[@PowerExbyJitendra]

नमस्कार अति आभार प्रकट करता हूँ

[@ecstasy6913]

#N/A error !

[@PowerExbyJitendra]

Please apply function carefully

[@ecstasy6913]

I did, but this method worked for me kzbin.info/www/bejne/ep-wlpd9j9WLgLM @@PowerExbyJitendra