Excel Advanced Vlookup Formula in Tamil | Get 1st 2nd 3rd Matches using VLOOKUP | Prabas MS Office

[@smtax4138]

Hi sir super

[@Prabasmsoffice]

Hope you understand it better.

[@apn6824]

அருமையான பதிவு பிரபாகரன்... Invoice ல் கம்பெனி பெயர், unique id, மற்றும் rupees in words வருவதர்க்கு உங்களின் புது technique தேவை படுகிறது...Expecting your videos at the earliest...வாழ்க வளமுடன்...

[@Prabasmsoffice]

நன்றி. நம்பிக்கையோடு காத்திருங்கள்.

[@kande578]

Thanks a lot bro. Very useful

[@aravindhdevendran6522]

Very Awesome sir

[@amjathbasha9828]

Very useful.

[@varmas7537]

super bro your videos much helping me. Thank you

[@solaiappanravi7674]

Thank you sir Now I have to clear my doubts.

[@kalyanaramansundaram8348]

Your xl tutor videos are excellent. Pl enlighten how to incorporate an another drop down list for dates or year wise in the existing example, so that we will have two options ie customerwise year wise .

[@Prabasmsoffice]

Good task. Share the Excel Dummy sample to [e-mail]

[@ameerhamja2893]

Yes dear sir .I want full video .

[@prammanayagam.s9869]

Thank u so much ❤️

[@shanmugaraj1096]

Superb and useful video... i found an idea for my pronlonged problem. Thanks. Explain that "points to think"

[@sivakumarcp6705]

Unique logic innovate ideas explained in your amazing teaching skill . Thanks a lot

[@Ridetoright111]

Excellent..!! Very useful..Prabha

[@Prabasmsoffice]

👍👍

[@ltavm7822]

Unique conversation 👌 tips very useful for me, for v lookup using time. Super sir tq.

[@praveeng3921]

Your Great, since i have doubt in my mind while watching your videos, but your covered my doubt as well, i m surprised bro..... I M BIG FAN OF YOU.

[@Prabasmsoffice]

Sounds good. 🙏

[@praveeng3921]

@@Prabasmsoffice Bro tell me how to get the unique value for drop down in this video you have done.

[@Prabasmsoffice]

@@praveeng3921 Sure, will make a seperate video.

[@kannans7391]

Excellent sir,🙏🙏🙏

[@Prabasmsoffice]

Thanks for your support

[@saravanakumar4160]

Sir, idhe idea va monthly production sheetla use pana mudiyuma?

[@Prabasmsoffice]

முடியும்

[@sankarannarayanan6437]

Very helpful for me

[@Prabasmsoffice]

Thanks, there are many VLOOKUP tutorials. We also have a playlist for vlookup. Kindly explore them.

[@ramzein776]

very useful video Sir, Thanks a lot as iwas searching this .. Thanks you so much

[@Prabasmsoffice]

Keep searching and learning 😊

[@rajasanthosh9617]

Sema sir, Video podunga sir eppadi numbers words ah maruthunu

[@Prabasmsoffice]

Sure Raja

[@sachinsathish7484]

Hi nice 😊 this video lot of learn from this concept get the various different things and will try upload the video new things congrats

[@Prabasmsoffice]

Glad that you liked it. Keep supporting.

[@sridharjee9096]

Hi bro... How to varify two excel.. One excel I want use as base and daily report need merge wherever changes I am getting... wants to update with new cases and wherever they removed some row I wants get to know that also

[@marxp9722]

Lovely great you sir

[@Prabasmsoffice]

Keep exploring other videos also from our KZbin channel.

[@fayazudeen6660]

Excellent bro ur teaching is so nice

[@Prabasmsoffice]

Appreciate your comment.

[@basiljacob18]

Superb bro..very interesting

[@Prabasmsoffice]

Apologies Jacob, I couldn't take class on the topic you requested. I was busy and still the same. I will let you Know soon.

[@arunsaravanan2001]

hello sir naan romba naal unga video watch pannikitu irrukken rombs usefulla irrukku enakku oru data extract panna try panna parthithen annal ennal correct km kandu pudikamudiyalla so please ennakku from & to place sammanthama oru coloumn irtukurathulla another table from and to place type panninaal km find pannurathukku ethavuthtu solution sollunga sir thank you

[@Prabasmsoffice]

Share me the Excel files in email and send me a voice recording of your complete requirements. I will try to address

[@karthickrajalearn]

In 8m 53rd Sec Amazing Connection Point 9m 12sec Amazing Sir F9 Shortcut Key Preview of Concatenated Formula In 15m 46sec I need one more video

[@Prabasmsoffice]

Thanks Karthik (long time supporter)

[@nijamabu1424]

Bro, vlookup la barcode differents kandu pudikkanum, but perfect ah utkara mattithu konja edhachu easy suggestion iruntha sollunga....

[@balajikannan4896]

Your job priceless Sir I'm enjoying each and every video Sir want to learn VBA pls help

[@Prabasmsoffice]

Sure, your request is noted

[@ranjithrash5329]

Very interesting bro. Its easy to understand to create a invoice. As you told i will try to get the numeric values comes into text. Also i ll try the unique of Code (which is A0001, A0002, Etc......)

[@Prabasmsoffice]

Thanks ranjith, keep learning and referring us.

[@ranjithrash5329]

Spell number!!!!

[@dm-zd5nu]

innovative concepts bro. i try to find the answer for ur questions..before just one clarification have u use any coding for numeric values converted into words?

[@Prabasmsoffice]

No Dinesh. Formula only.

[@sreeharanbn2800]

Dear Sir, I am very much interested to know this formula. Can you please reveal it, at the earliest please?

[@sureshzachariahnelson7902]

Sir in my work place in oder to book invoices my audit team approves the bill item wise in the invoice not invoice number wise, so now I have the data column containg date/vendor/invoice number/item/amt/Audit status(Approved or hold), in this case if I use vlookup to check whether approved or hold, vlookup function giving only first relevant output , how to get all output of item wise. Please suggest

[@Prabasmsoffice]

It is possible brother, share a sample Excel file to [e-mail]. we will discuss then.

[@sureshzachariahnelson7902]

@@Prabasmsoffice sir I mailed sample file

[@ashokumarv6792]

Can you Please place a video video for searchable drop down

[@Prabasmsoffice]

Sure soon.

[@vickyrodriguez4779]

Hi Sir please do one video for normal lookup function example =lookup( not a vlookup And one more video for instead of entering column index no how to do the same in dynamic way in all types of Excel version

[@Prabasmsoffice]

Sure will add one

[@devadoss8391]

Rs in word varuvatharku na Suresh addin use panuthan

[@HariKumar-ru9no]

Sir, you are using spell number formula for making Number as Text. But please provide unique Drop down list video.if already posted. Please share link.

[@Prabasmsoffice]

I will Make one video for this.

[@rajasanthosh9617]

Sir, one help intha video la unique concept video link send pannuga sir

[@Prabasmsoffice]

kzbin.info/www/bejne/kJSWm5aFbLyCbM0

[@rajasanthosh9617]

Thank U so much sir

[@sureshp2635]

Bro ...i need help bro ...date to date match lookup panna mudiyuma ha ..

[@Prabasmsoffice]

Possible

[@MegaSiva003]

sir i have 2k part number, repeated comming how to one part number total find out panrathu?

[@Prabasmsoffice]

=countA(unique ( select a range))

[@MegaSiva003]

@@Prabasmsoffice Ple share u r mail id sir

[@Prabasmsoffice]

[e-mail]

[@jpanbucomputers]

thanks for download like share i need Can you do this with birthday date and the letters and numbers you used

[@Prabasmsoffice]

Yes, you can use this any kind of data. But you should follow the steps.

[@jpanbucomputers]

@@Prabasmsoffice sure

[@BooBalan_]

Spr na 🤗

[@Prabasmsoffice]

Thanks Boopalan for being a subscriber of Prabas MS office

[@mohammedfarook5376]

super

[@Prabasmsoffice]

Thanks for posting a positive comment.

[@ManiKandan-rm5jk]

Sir, How to use this formula for 2 weekend days after 6 working days???

[@chappu83]

Congratulations for reach 11k👏👏👏

[@Prabasmsoffice]

It is all because of you. I liable to all my subscribers. Thanks for making this a great move.

[@chappu83]

Your great teacher for me thanks a lot 💚💚

[@Dineshkumar-gz7vh]

how to download practice file ? searching the file is difficult plz simplfy this

[@Prabasmsoffice]

Sure, what do you think nthe search bar. Have you used it.

[@cmamanjunathankaruppannan6098]

in vlookup, i need the last data in a table for the lookup value.

[@Prabasmsoffice]

Use XLookUp

[@shahnizar]

Please explain about Ad-Hoc reporting in Excel...

[@Prabasmsoffice]

Sure, I will definitely make a video on Ad-Hoc report. If you have any special sample or requirement, share the working excel to me, it is easy for me to work on the video.

[@Ridetoright111]

Prabha.. Suspense venam .please video podunga... video continuity.

[@Prabasmsoffice]

Sure

[@executiveofficerpanpoli6253]

Amazing

[@Prabasmsoffice]

Thanks for posting your comment. Appreciate your learning interest.

[@Sk_Gamer0255]

drop down list la epadi refference eduthaiganu oru video poduga bro pls iam beginning so I am not understand Last reference drop down list pls plz

[@Prabasmsoffice]

Sure, your request is noted.

[@mohankumar-ir5kn]

How to do vlookup in same sheet

[@Prabasmsoffice]

It is easy, watch the following video, use the same concept with this concept. kzbin.info/www/bejne/fX68lohjfc6osNE

[@devadoss8391]

Verry useful but unique a vera vaikka theriyala na remove duplicate pani panuthan so atha pathina video va podunga sir

[@Prabasmsoffice]

Sure Devadoss. Thanks for your hope.

[@dineshmani8062]

Ji try it convert number to words.i searched the net there is long VBA code available in different websites some of them provide add in for this.ji it is totally different for me so kindly make u the video with explanation ji.i try to find solution atleast ur second question

[@Prabasmsoffice]

Sure Dinesh mani. Keep expecting and learning.

[@Prabasmsoffice]

Location for practice file is. www.prabastech.in/free-downloads/

[@solaiappanravi7674]

Really great thank you sir for your reply 😀😀😀👍

[@HariKumar-ru9no]

I tried to download file. But can't able to download. Pls advice

[@hajajahirhussain6814]

hi bro, I know the formula for converting numeric value into text.. Useing choose, left,mid, right and if formulas.. it's a simple but very big formula. I tried and created one. Thanks to Leila Gharani..

[@Prabasmsoffice]

Superb Haja, it is such a wonderful Formula.

[@hajajahirhussain6814]

@@Prabasmsoffice Prabas MS Office Yes sir. Intha video naan romba naal edhir partha video.. Ithu maari advance excel ku video podunga.. kandipa unique value extraction, excel array concept, dynamic arrays, dependent drop-down list ellatha pathium video podunga ji

[@agragunath]

Unique dropdown plus number to text please upload a video

[@Prabasmsoffice]

Sure, நம்பிக்கையோடு காத்து இருங்கள்.

[@agragunath]

@@Prabasmsoffice thanks in advance

[@sathyarajboopalan9464]

Athu niga pivot table pottu irukiga sir

[@Prabasmsoffice]

Correct Sathiyaraj Boopalan. Did you find the other methods.

[@namakuethukuoorvambu_neov7166]

Really helpful for me and I need another additional information for scenario if you intreast to help me kindly reply my msg. Thanks

[@Prabasmsoffice]

Explain your requirement.

[@namakuethukuoorvambu_neov7166]

@@Prabasmsoffice am really sorry what I am try to say

[@krishindira9234]

Content good but audio very bad

[@Prabasmsoffice]

Feedback taken, thanks.

[@dhineshkumaran3809]

Sir I'm using if condision for yes or no for vlookup function Ex. 1 10 2 20 3 30 Now I'm using if(Vlookup ) 1 10 need results is "yes" 4 n/a need results is "no" How to get tha result yes or no Need formula sir

[@jpanbucomputers]

I WILL TRY BUT NOT WORKING

[@Prabasmsoffice]

Do share the output to [e-mail]

[@jpanbucomputers]

@@Prabasmsoffice I'm already send it My email address: [e-mail]