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 powerexbyjitendra@gmail.com
@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🧐