Vlookup With Transpose Function
HTML-код
- Опубликовано: 23 май 2021
- 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.com/BymUIDEt3ME...
--------------------------------------------------------------
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
आप हमारे चैनल को Subscribe करे।
ruclips.net/channel/UC8Vu...
Thank you Sir !
Thank you
It showing. #value!
It not showing in 2007 Excel
Thanks. How do you do the reverse action? Bottom list to the top list pls?
Did you get answer?? Pls share
Hi sir just iska opp ka example bataye where array is vertical and data need in horizontal
With 2 match conditions
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