Very good technique sir, thanks for this, I used to understand that vlookup can not be used broadly but by watching this video I come to this conclusion that it is very very unique formula we have. really
Sir, your this video solved my biggest problem in excel i was trying to understand indirect function from 1.5 years but your this video made me understand it. Keep posting videos sir.
Thank you so much.. seriously learning alot from you.. you made vlookup concept so easy to understand... had been trying to do so from long time ... thank you
Sir Is formula mein b colum invoice wala sab mein same place pe hai yani b mein . Agar hum customer name ya amount inovice wale b column se pehle rakh de to ye kaam karega. Kyonki maine try kiya is tarah se to nahi huaa. Pls solution it. And one question more Agar mere sheet mein delhi 20-50 baar repeat hai aur us ki amout value Delhi wale colum left mein hai aur mujhe kisi aur sheet per all delhi ki value one by one chahiye to kaise hoga . Please solution it
can we use vlookup or some other function to match values even when there is minute difference in Lookup value like "GST/20" and "20" or say "30/20-21" & "30"
Sir thanks for ur extended beautiful support on excel. Sir i have one doubt. I am using Vlookup from one sheet to another sheet whereas in the source sheet multiplication formulas are there and i want to match it with vlookup error ah raha. Pls sir can u pls clear my doubt and solve it pls
Very useful demonstration. But I couldn't understand few steps due to language prob. I would have understood fully if it had been in English. Can you or any one else help me in this regard. Still I am not clear.
Are sir ji mera ek ques. He ki mere pass bahut sare yese hi state wise data he par me ek file ka data diffrence difference sheet me data lena chahta hu to koi new formula bataiye na
Very good technique sir, thanks for this, But I have 1 doubt, invoice no in all sheets in column 2 only, if invoice no's also in different columns in diff sheets, whether this functions will work.
This is the basic rule of vlookup that the field on which you are putting vlookup formula should be on extreme left hand side. In our case that field is Invoice no. This will not work if you will shift that field. But you can change the position of other fields. Hope this will clarify your doubt.
@@fintaxprime thank a lot for your reply, I also thought the same sir, but I asked again that doubt to know if there is any formula or shortcut for this problem also
Dear Sir, I have watched your mind blowing tutorial and it helps me a lot to understand vlookup with indirect function. I have a query that is it possible to fetch data from different worksheets of a workbook to another excel workbook with the help of vlookup and indirect function? If it is possible, I request you plz make a tutorial on this topic. Thanks..... Jayanta Bhattacharyya.
Sir, is the formula work without the location column in sheet 1 or how can we extract the lookup data only with the invoice no. From different sheets . Sir plz do revert will be waiting for your reply. Thank U
Sir plz help me . I want vlookup with dynemic workbook . My data every workbook are same range. When I enter a id no in a cell and the cell value is workbook name .
sir i am facing problem in applying vlookup with indirect function #ref error but without indirect function it works properly both syntax are =VLOOKUP(B2,INDIRECT(A2&"[08-10-2019.xlsx]08-10-2019!$A:$G"),3,0) =VLOOKUP(B3,'[08-10-2019.xlsx]08-10-2019'!$B:$G,3,0) so please highly requested to u to tell my mistake
Hi Tanmay, can you please put formula in excel on some sample data and sent it to me on caamitjain2018@gmail.com. I'll check and let you know the exact issue.
Very good technique sir, thanks for this, I used to understand that vlookup can not be used broadly but by watching this video I come to this conclusion that it is very very unique formula we have. really
Awesome sir jii
keep smiling..... and sharing like this interesting video, love you sir
Very good 👍 Kiya baat hai sir
"Chandigaaad!"....lol...very entertaining to hear that!
BRAIN IS THERE,Allah aaap kaaay ilm maay izaafa karaay.AAmeen.
Superb!
Best way to explain Thank you
Really appreciate for your teaching and sharing the practical file.
Sir, your this video solved my biggest problem in excel i was trying to understand indirect function from 1.5 years but your this video made me understand it. Keep posting videos sir.
Thanks you for liking my video.
Mind-blowing explanation. You are really passionate about sharing your knowledge. Subscribed when I saw the advanced pivot video.
Your videos are very useful.
Keep doing it. 👍
Awesome
Keep it up
Awesome
This will very useful in our profession.
Your way of teaching is also awesome
Thank you sirji
Thank you for liking my video....
Very interesting
Thank you for sharing
Amazing video Sir Interesting 💯times work multiply with this
Thank you so much.. seriously learning alot from you.. you made vlookup concept so easy to understand... had been trying to do so from long time ... thank you
Thank you for liking my video....
Superb Sir, well explained, you are genious,. Thanks
Thank you for liking my video....
Great vid this is my favourite formula. U are too gud
Nice experiment Sir
Useful research
Thank you for liking my video....
Excellent man
Bhai agar agar baki sheet me table bhi upar niche ho to????
good work, thanks
This is very useful function sir.
I have to ask one thing that can we prepare one summary like this in pivot table from different worksheets?
Thank you for good lecture.
Very nice Sir,
One more problem is that table range location is also different in all sheets, how we tackle the problem
Thanks
Perfect explanation.
Sir agar cell main formula lagga hua hai toh is it possible to bring that formula in v lookup
Excellent!!
Sir
Is formula mein b colum invoice wala sab mein same place pe hai yani b mein . Agar hum customer name ya amount inovice wale b column se pehle rakh de to ye kaam karega.
Kyonki maine try kiya is tarah se to nahi huaa. Pls solution it.
And one question more
Agar mere sheet mein delhi 20-50 baar repeat hai aur us ki amout value
Delhi wale colum left mein hai aur mujhe kisi aur sheet per all delhi ki value one by one chahiye to kaise hoga .
Please solution it
Nicee
Very complicated, but informative
can we use vlookup or some other function to match values even when there is minute difference in Lookup value like "GST/20" and "20" or say "30/20-21" & "30"
Sir thanks for ur extended beautiful support on excel. Sir i have one doubt. I am using Vlookup from one sheet to another sheet whereas in the source sheet multiplication formulas are there and i want to match it with vlookup error ah raha. Pls sir can u pls clear my doubt and solve it pls
Dear sir,
Very much happy to learn.
Your session are highly informative.Thank you. If you could add these practice sheets that would be great
Thanks a lot , Practice files always added in description of videos
sir if you don't create location column how i will do it.
i have also these type of sheets,so i will try this, i love excel... and i want to become baba e excel.... like hight expertise...
Excellent video.
How to Vlook up from another excel which contains multiple sheet?
Thanks in advance.
Very useful demonstration. But I couldn't understand few steps due to language prob. I would have understood fully if it had been in English. Can you or any one else help me in this regard. Still I am not clear.
Are sir ji mera ek ques. He ki mere pass bahut sare yese hi state wise data he par me ek file ka data diffrence difference sheet me data lena chahta hu to koi new formula bataiye na
Very good technique sir, thanks for this,
But I have 1 doubt, invoice no in all sheets in column 2 only, if invoice no's also in different columns in diff sheets, whether this functions will work.
This is the basic rule of vlookup that the field on which you are putting vlookup formula should be on extreme left hand side. In our case that field is Invoice no. This will not work if you will shift that field. But you can change the position of other fields. Hope this will clarify your doubt.
@@fintaxprime thank a lot for your reply, I also thought the same sir, but I asked again that doubt to know if there is any formula or shortcut for this problem also
Dear Sir,
I have watched your mind blowing tutorial and it helps me a lot to understand vlookup with indirect function. I have a query that is it possible to fetch data from different worksheets of a workbook to another excel workbook with the help of vlookup and indirect function? If it is possible, I request you plz make a tutorial on this topic. Thanks.....
Jayanta Bhattacharyya.
Yes that is possible. Will try to prepare the same.
Thanks Sir. Eagerly waiting for that.
Sir, is the formula work without the location column in sheet 1 or how can we extract the lookup data only with the invoice no. From different sheets . Sir plz do revert will be waiting for your reply. Thank U
It will not work without location column.
Right 😉
can anybody help what I need to change if there is space in sheet name like if i write ag ra instead of agra?
sir how we make a column DUE ON
Make a comprehensive video on GSTR 9 and GSTR 9C.... please...sir
Sir plz help me . I want vlookup with dynemic workbook . My data every workbook are same range. When I enter a id no in a cell and the cell value is workbook name .
Hi, can you please share your issue explaining with example in excel on caamitjain2018@gmail.com
Formula dikhta nahi h aap thoda zoom karke dikhaya kare
sir i am facing problem in applying vlookup with indirect function #ref error but without indirect function it works properly both syntax are =VLOOKUP(B2,INDIRECT(A2&"[08-10-2019.xlsx]08-10-2019!$A:$G"),3,0)
=VLOOKUP(B3,'[08-10-2019.xlsx]08-10-2019'!$B:$G,3,0)
so please highly requested to u to tell my mistake
Hi Tanmay, can you please put formula in excel on some sample data and sent it to me on caamitjain2018@gmail.com. I'll check and let you know the exact issue.
Good Morning sir, sir agar ham invoice according data pickup kara apki data sa. it s possible
Hi, can you please explain your query in details. If possible, please share the same on caamitjain2018@gmail.com.
Sir reference error aa Raha hai
Can you please share exact issue. It's better if you can share formula.
@@fintaxprime okay sir
Sir would pls make the more videos on macro ....🙂🙂🙂
Yes I'll definitely do the same.
Sir, plz make video on Index formula, and making it dynamic. Plzzz make one request. With example and possible errors. Plzzz sir
Hi, Will try to prepare it soon.
Thanks
1 sheet me data ko difference difference state wise data usi name ki sheet me aa jaye
Please make video on Gstr9
Please sir ji iske upar ek video banayiye
SUBRIBED YU