VLOOKUP Across Sheets | VLOOKUP + INDIRECT | VLOOKUP MATCH | MIS Interview Question

[@NaveenKumar-or2iv]

Very useful Video Thanks sir

[@PowerExbyJitendra]

Thanks a lot

[@baharali7429]

Very informative and helpful video Thanks.

[@PowerExbyJitendra]

Thanks a lot

[@deepreet9091]

Awesome video sir thank u for this video

[@PowerExbyJitendra]

Thanks a lot🙏

[@yashpatil3375]

Excellent 👌 very nice

[@PowerExbyJitendra]

Thanks a lot

[@manjit.sarania]

Very helpful sir. 🙏🙏🙏

[@PowerExbyJitendra]

Thanks a lot

[@777pbp]

What if data is in other workbook

[@purnimakundu1239]

Plz view the if error formula

[@prashanttyagi1156]

Vey informative brother, but with one doubt, agar abhi to example mein sabhi sheets ke coloum ik hi format mein i mean series mein hain, agar kusibsheets mein date 5 coloum mein , matlab sabhi sheets mein coloum aage peeche hi to phir kaise karenge

[@PowerExbyJitendra]

Column different bhi honge to bhi no problem Iske liye apko column index no se pahle Indirect formula use karna hoga

[@RahulRoy-po9ct]

🙏

[@PowerExbyJitendra]

Thanks

[@purnimakundu1239]

Plz give formula to find GST n total pls sir

[@PowerExbyJitendra]

Ok zaroor

[@purnimakundu1239]

@@PowerExbyJitendra when will you give formula of GST n total n lso give other vlookup n if errorformula

[@prashanttyagi1156]

Mere pass kuch aap ke trah sheets hain aise hivsummary sheets hai branch wise. Us mein jo formula lagaya hai maine vlookup+indirect,match +indirect. Mere wali sheets mein result aaataa hai but aap wali sheet mein is apne formula ko apply kerta huun to ref error aata hai bhut try ker chuka huun . Mera formula hai =vlookup($b2,indirect($a2&"!a:i"),match(c$1,indirect($a2&"!a1:i1"),0),0)

[@prashanttyagi1156]

Kuch help kijiye kajan galti hai mujh se data bilkool aap wali sheet ke format mein hai.

[@PowerExbyJitendra]

Please send your excel sheet [e-mail]

[@prashanttyagi1156]

Mere kehne ka matlab jo aap wali sheet hai us mein is vlookup($b2,indirect($a2&"!a:i"),match(c$1,indirect($a2&"!a1:i1"),0),0) se result nikalna hai but ref error aata hai aaki sheet mein patna nahi kyon , mere sheet mein , aap plz apni sheet per is formule jo aapply kerke dekhiye ref error kyon aata hai

[@lovekibaat4328]

Mere liye ye excel ke formule kisi physics se kam ni🧐

[@PowerExbyJitendra]

Thanks