Vlookup With Transpose Function
ฝัง
- เผยแพร่เมื่อ 10 ต.ค. 2024
- In this video we learn how lookup from Horizontal data to Vertical.
Used Function
#VLOOKUP
#TRANSPOSE
In case of any simple or complicated "EXCEL" QUERY, You can join our WhatsApp Group for instant solution @ chat.whatsapp....
--------------------------------------------------------------
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
आप हमारे चैनल को Subscribe करे।
www.youtube.co....
Thank you Sir !
Can you pls explain for Vertical to Horizontal format.
Sure....will upload a video shortly.
Thank you
Thanks. How do you do the reverse action? Bottom list to the top list pls?
Did you get answer?? Pls share
It showing. #value!
Hi sir just iska opp ka example bataye where array is vertical and data need in horizontal
With 2 match conditions
Will share video on this soon
Sure ..will share video
TRANSPOSE KRTAY WAQT AGAR DATA CHANGE KRTAY HEIN TU WOH TABLE MIEN MOOJOD DATA KO BHI UPDATE KRAY.. PLZ YEH MASLA SOLVE KER DIEN K VLOOK UP SAY EXTRACT KIYA GYA DATA PEECHAY TABLE MEIN DATA UPDATE KRAY
Ok..will share formula shortly
It not showing in 2007 Excel
Please check again...you can use teanspose in 2007