Vlookup With Transpose Function

[@souvikdas9110]

Use index+match or advance sumproduct formula instead of using the same formula 3 times..

[@salmanpathan6491]

Thank you

[@SheelgandhChandankhede]

Horizontal to vertical which function is used in excel

[@ExcelWorldmis]

@@SheelgandhChandankhede Hlookup function.
Will upload video on this soon.

[@ChiragPatel-rm9me]

Can you pls explain for Vertical to Horizontal format.

[@ExcelWorldmis]

Sure....will upload a video shortly.

[@eo3728]

Thanks. How do you do the reverse action? Bottom list to the top list pls?

[@Reactionn17]

Did you get answer?? Pls share

[@ExcelWorldmis]

th-cam.com/video/OMcwM8BxRlA/w-d-xo.htmlsi=0iVzHdTDwPlzCJ8C

[@biswajitrai3574]

It showing. #value!

[@ExcelWorldmis]

Ctr+shift+enter kijiye

[@KidsHappinessWorld987]

Hi sir just iska opp ka example bataye where array is vertical and data need in horizontal

[@KidsHappinessWorld987]

With 2 match conditions

[@ExcelWorldmis]

Will share video on this soon

[@ExcelWorldmis]

Sure ..will share video

[@sanaokarian6169]

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

[@ExcelWorldmis]

Ok..will share formula shortly

[@GajendraGaji-mh2sb]

It not showing in 2007 Excel

[@ExcelWorldmis]

Please check again...you can use teanspose in 2007