Vlookup with Multiple Sheets Lookup with Match and Indirect Function
HTML-код
- Опубликовано: 1 окт 2024
- In this video you will learn,
1. how to use vlookup function with multiple sheets using Indirect and Match Function.
2. How to develop your own big formula using small functions in excel.
Practice file can be downloaded from below link:
www.dropbox.co...
Very interesting
Awesome sir jii
Right 😉
"Chandigaaad!"....lol...very entertaining to hear that!
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
Make a comprehensive video on GSTR 9 and GSTR 9C.... please...sir
BRAIN IS THERE,Allah aaap kaaay ilm maay izaafa karaay.AAmeen.
Bhai agar agar baki sheet me table bhi upar niche ho to????
Nicee
Best way to explain Thank you
Very nice Sir,
One more problem is that table range location is also different in all sheets, how we tackle the problem
Thanks
Formula dikhta nahi h aap thoda zoom karke dikhaya kare
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.
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?
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
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
sir how we make a column DUE ON
Thank you for sharing
Sir agar cell main formula lagga hua hai toh is it possible to bring that formula in v lookup
sir if you don't create location column how i will do it.
good work, thanks
Very complicated, but informative
Excellent man
Excellent!!
Thanks
SUBRIBED YU
Excellent video.
How to Vlook up from another excel which contains multiple sheet?
Thanks in advance.
Great vid this is my favourite formula. U are too gud
Amazing video Sir Interesting 💯times work multiply with this
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. 👍
Thank you for good lecture.
Really appreciate for your teaching and sharing the practical file.
Very good 👍 Kiya baat hai sir
Awesome
This will very useful in our profession.
Your way of teaching is also awesome
Thank you sirji
Thank you for liking my video....
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...
Superb!
Perfect explanation.
Awesome
Keep it up
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"
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....
keep smiling..... and sharing like this interesting video, love you sir
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
can anybody help what I need to change if there is space in sheet name like if i write ag ra instead of agra?
1 sheet me data ko difference difference state wise data usi name ki sheet me aa jaye
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.
Sir reference error aa Raha hai
Can you please share exact issue. It's better if you can share formula.
@@fintaxprime okay sir
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
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.
Please make video on Gstr9
Please sir ji iske upar ek video banayiye
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.
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 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
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.
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.
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 would pls make the more videos on macro ....🙂🙂🙂
Yes I'll definitely do the same.
Nice experiment Sir
Useful research
Thank you for liking my video....