Extract data from multiple sheets in a single sheet in excel in

[@MDataFinnovatics]

Call us at [phone] for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍

[@arvindtech408]

Sir first time indirect function aur sum product function samajh aya h.... sir complex formula ko kitna easy explain kiya h apne pura TH-cam par apk jaisa basic se btana wala koi nhi h

[@akashdeepdhiman6775]

=INDIRECT(SUBSTITUTE(F2," ","_")) For Creating Drop-down list based on states because Uttar Pradesh has a space in its name..thanks for the video sir and for useful content

[@cutoworld7425]

Very very knowledgeable video sir. Thanks for enhancing our knowledge

[@MDataFinnovatics]

Thank you Cuto World. Don't forget to like and share the video!

[@usamahqamar6148]

Very helpful thanks

[@Matawfik]

Indian speaking but excellent demonstration. Thanks a ton.
Big like and subscribe for attaching the working file. 👍👍

[@MDataFinnovatics]

Thanks, Tawfik for liking the video and also for the subscription!

[@nitish709011]

Hello @MDataFinnovatics :- If tab names are by Month and year names, how to write an Indirect function ? I tried but its giving #REF error.

[@ubaidillahmuhammad20]

amazing job. please make video how to lookup case sensitive ....., with vlookup

[@MDataFinnovatics]

Thanks Mohammad. You can use Upper, Lower, and Proper for a specific case sensitive. But we will try to create a video on case sensitive with VLOOKUP. Don't forget to like and share the video!

[@ubaidillahmuhammad20]

prpper, lower n upper don't work..

[@MDataFinnovatics]

Please share your scenario so that we can provide you some solution!

[@sanjubharat19]

Hi Sir plz share the ans of last question which you had given to us for homework

[@yashpatil3375]

Very nice sir ji 👍

[@secondarylaptop]

=INDIRECT(A1)
this gives refrence error

[@ajaybhamare5646]

I hope u understood my doubt ...if not plz let me know!!!!