Search Box in Excel using VLOOKUP | No VBA

Search Box in Excel using VLOOKUP | No VBA
This video is about creating a search box in Excel using VLOOKUP, no VBA. I have already uploaded many videos on search box but this is very special for all.
So please watch the video and if you find it valuable please subscribe our channel:
/ powerexbyjitendra
And if you want to download our file, click on below link:
==============================
docs.google.com/spreadsheets/...
==============================
Related Videos:
1. How to Create an Automatic Search Box in Excel Using Vlookup
• How to Create an Autom...
2. Advanced Search Box in Excel using Conditional Formatting
• Advanced Search Box in...
3. How to create a Search Box in Excel
• How to create a Search...
4. Search Box in Excel by using Advanced Filter and Macro
• Search Box in Excel by...
5. Vlookup Formula in MS Excel with Examples
• Vlookup Formula in MS ...
6. How to Get Multiple Results by Using Vlookup Formula with Columns Formula in MS - Excel in Hindi
• How to Get Multiple Re...
7. If Function in Excel in Hindi
• If Function in Excel i...
------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#searchbox
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
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

[@mohammadilyas2260]

Great job really informative for all working in EXCEL U R great Excellent زبردست

[@PowerExbyJitendra]

Thanks a lot

[@AdvancePower]

VERY NICE AND HELPFULL THANKU SIR☺

[@maniyangameplay]

its a greate teaching.....in a very good way.... you r really a teacher meterial... well done

[@PowerExbyJitendra]

Thanks for your compliment

[@yasinshaikh1574]

Greatfull thank you so much for to provide each and single details in this video

[@PowerExbyJitendra]

Thanks a lot

[@ra.mmusic8725]

Thanks for this video Me is tyaka data table banane ke liye pichhle tin dinse paresan tha thank you sir.......

[@PowerExbyJitendra]

You are welcome

[@snasar0nasar]

Thanks bro for sharing such a wonderful information ❤❤❤

[@PowerExbyJitendra]

Thank you so much

[@biswajitkaran89]

Very very useful and formative and amazing.

[@PowerExbyJitendra]

Thanks

[@baharali7429]

Excellent work Sir 👍

[@PowerExbyJitendra]

Thanks

[@deepakkhurana9617]

बहुत badiya सर ,आपकी इस वीडियो की वजह से मेरी बहुत बड़ी प्रोब्लम सॉल्व हो गई ,में बहुत ही preshan था ,आपकी वीडियो देखते ही काम हो गया।👌

[@PowerExbyJitendra]

Thanks a lot

[@deepakkhurana9617]

Hello sir Ek file me hyperlink ko advance banana hai ,ya to aap is par koi video ho to woh bhej dijiye ,nahi to sir meri ek file hai ,aap us par laga dijiye, please sir Me is file ko leker bhi bahut problem me hu

[@gr8lakhogame]

Very helpful vlookup mene kafi istmal kia h mukhtalif tareeqe s ek or col ka milgaya thank

[@PowerExbyJitendra]

Thanks a lot🌹

[@user-el5sg2bz7l]

How about any column to search? Can you help me? Thanks

[@ramkumar-lh5mq]

Thanks for this knowledge. I have one problem if same number or text in multiple column then how can find them like you (B Grocer 1, B Grocer 2..........)

[@lalat007]

Excellent Sir

[@PowerExbyJitendra]

Thanks

[@saimahashmi4058]

Plz create a tutorial on data entery form and search box that we could use on mobiles thanks

[@abdulsalam935]

Sir, extremely good.But, can you do above video using INDEX+SMALL+IF+ROW function. Or if you have already done, please share link. thank you.

[@rahulcomputercentre2463]

Love ❤️ you sir

[@PowerExbyJitendra]

Thank you Rahul

[@AsadShaheenAkram]

Excellent

[@PowerExbyJitendra]

Thanks

[@Allin1-369]

Wonder video sir ji

[@PowerExbyJitendra]

Thanks ji

[@umairzahid3743]

Zabardast sir very beautiful

[@PowerExbyJitendra]

Thanks

[@vishalagrawal8717]

Excellent bro.... Can u help to know if we can do paste value special while we had applied of filter?

[@PowerExbyJitendra]

Thanks

[@user-dm2pw4jn4g]

Thanks, it is helpful, but one problem is that after 25 th row it will not show the results if there is lists

[@sadiqulalam8863]

Sir mera ek table hay jisme helper column ka formula auto expand nahi ho raha hai. Aur helper column me "formula omits adjacent cells" error araha hai. But uska reason nahi pata .

[@user-el5sg2bz7l]

Nice. How about any column to search? Is this possible?

[@bikashrai8582]

❤❤❤great

[@PowerExbyJitendra]

Thanks

[@mirashmichu1815]

Can we apply 2 vlookups for the same cell.. As which shown in your video....

[@zeeshansaqlain9498]

Ma daily basis pay large data excel ma enter krta hn to kya ya search box ma automatically a jy ga ya jo data ply say enter ha ya sirf us k according kam kry ga

[@gursewakbhullar8951]

Sir second lookup in search bar is not working according to first letter of word search. If possible please guide.

[@ramkumarchourasia8030]

My data file is too long and after putting Vlookup as you suggested My Microsoft is responding very late. How can I speed up

[@manindermanu6597]

Sir filtter date range ka v video banao.

[@friendsframings]

very nice Sir

[@PowerExbyJitendra]

Thanks a lot

[@quareshi999]

Thanks lot

[@PowerExbyJitendra]

Thanks

[@Sonayoutuber_12]

Sir mere gst clients H to kya hume grocer 1 ye sb identity dena jruri H

[@azreenazaharil5217]

Hi, how if i wanna show dates in date format ? Thank you

[@chandrum814]

This trick really helpful me but I need another 1 trick this sheet final total summery need please help mee

[@goutamseshu6193]

Thank you sir , it's very helpful to me

[@PowerExbyJitendra]

Welcome

[@kohteik1112]

thank so much

[@PowerExbyJitendra]

Welcome

[@PowerExbyJitendra]

Welcome

[@cadmasterbd]

amazing, but i had a question to you, I have some data like (06/1SLUB, 6/1SLUB Sp-1, 6/1SLUB Sp-5, 6.5/1SLUB ,07/SLUB SPEC-38, 07/1FSIRO SPEC-3) Now I want, If I type 06/1 then I will show all the data which contain 06/1 and if I type 07 it will show all the data which contain 07 and starting by 07. Is it possible brother if thn how can I do please help me. I don't have filter function.

[@irfanmaknojia3666]

how can i creat serch box to serch data bases on date and store type ?

[@irfaanansari7748]

Super

[@PowerExbyJitendra]

Thanks

[@apexmobileselectronics9047]

Very nice and helpful. I have a question - how to show the results of people with the same first or last name example Mike Armstong, Mike Joe? Really appreciate

[@PowerExbyJitendra]

No issue in this case it will work. The problem will come there when the complete name is same. And that too has a solution.

[@apexmobileselectronics9047]

@@PowerExbyJitendra I got customers with same name as well. I mean One customer is using multiple services. How can we address that?

[@apexmobileselectronics9047]

@@PowerExbyJitendra Also, how to make it work by adding new details from time to time?

[@kailashsoni676]

Sir form se data entry krne ke baad sheet 2 pe jo data aata hai uspe search button wala concept work nhi krta plz help

[@nishantupadhyay5368]

Agar customer ka name different different colum me ho with different work to kaise use ek jagh le aye

[@vishalagrawal8717]

Can you make cheque print excel for different types of bank?

[@PowerExbyJitendra]

Yes

[@yasinshaikh1574]

Please advice : I have a excel sheet for my project employees..and I want to make excel sheet in which I can search the employees details by their employee codes..simple If I enter the employee code I want all the details should come on that least...plz help

[@amjadhasan7278]

I can help if you still need that

[@shribhagirathmal]

एक सर्च बोक्स में दूसरी व तीसरी रिपोर्ट सर्च करना हो तो कैसे बनाएं सर्च बोक्स जैसे एक कस्टूर है बी ग्रोसर उसने अलग अलग कम्पनियों का अलग अलग आइटम कई बार खरीदा तो उस कस्टूमर काअलग अलग कम्पनी वाइज एवं अलग अलग आइटम वाइज रिपोर्ट निकालने के लिए वीलुकप से कैसे सर्च बॉक्स बनाई जाती है।

[@gamingtv9616]

Hello sir, I need some help on this video, how I can contact you?

[@adnansheikh7355]

Search kiye huye data ko mark kar na ho ya edit karna ho to kar sakte hai kya

[@PowerExbyJitendra]

You can mark but not edit.

[@muhmmedalhmed2559]

Greetings to you ♥️🌹🌹 I tried to apply it in Arabic, but it did not work. Please respond in detail.

[@opgamerhacker2780]

Plz sir maine bahut baar mesg kiya aapko ek prog aisa bnaon jis mai new data, edit, delete ,search,view,print jaisa ek data banayenge sir plz

[@advanturegilgitbaltistanaq6799]

Good job bt is ma gar mazeed data add krna ho to kasy kry add to ho jata ha bt serch ma show nai hota

[@EndlessBharat]

around 3 min , when u search for e why it returned only B Grocer and didnt returned easy store?

[@PowerExbyJitendra]

First match will be returned by VLOOKUP. As B Grocer has alphabet e.

[@shanigondal5775]

Bhai koi tarika jo excel may save kiya sim contacts ko save krna ho apny phone may

[@cuteandsweet513]

I try this search box after vlookup drag to all cell come #N/A error

[@harichiman5804]

same

[@jetanodiya6595]

Sell ka total kaise lagagega is me

[@DanneAlfredLacorte]

Excellent, even i didnt understand the language, the process was so smooth, you derserve like and subcribe😊

[@PowerExbyJitendra]

Thanks you so much bro

[@munibsayed6433]

Product wise search

[@HamzahAli189]

Sir column function ka koi video bataye. I'm unable to understand this

[@PowerExbyJitendra]

Ok zaroor

[@maheswara5055]

Date kese add kare is search box me

[@sandeshbhesal2]

Par sar new entry karne ke baad unique vallue nahi aa rahi hai

[@sandeshbhesal2]

Helper collume main

[@hamidul6375]

this system apply in google sheet

[@amjadhasan7278]

You can use filter function in google sheets

[@Prabhat.Kumarhcl]

How to lookup up for data in multiple sheets

[@PowerExbyJitendra]

I have made a video on it please watch.

[@Prabhat.Kumarhcl]

@@PowerExbyJitendra link

[@PowerExbyJitendra]

kzbin.info/www/bejne/Y4mbaZeVgNp2o9k

[@vinaygaur270]

Any problem not solved

[@pravinagajjar6402]

Boghas. Dadi shem shem avi Boghas product ni jjaherat na karo pl

[@Hasanabdal9]

Drop down list does not work if sheet is protected

[@kundu9964922411]

Is not working with big data like 7/8/9 Lakhs data, any suggestion

[@akashbhauuu3723]

Split data or arrange it to alfa order