xlookup in excel in hindi || Xlookup A to Z in details || New Xlookup with Search Mode

  Рет қаралды 17,439

Gyan On Tube

Gyan On Tube

Күн бұрын

Пікірлер: 44
@arijeetkumarsharma226
@arijeetkumarsharma226 Жыл бұрын
Awesome As usual.
@GyanOnTube
@GyanOnTube Жыл бұрын
Thank you so much 🙏
@SanviPatil2019
@SanviPatil2019 3 жыл бұрын
Xlookup is god formula in excel history...
@GyanOnTube
@GyanOnTube 3 жыл бұрын
Very true it will remove all old function
@enlightenment9704
@enlightenment9704 2 жыл бұрын
Check out this video kzbin.info/www/bejne/f3Tahp58rryKg7M
@Tush__yaar
@Tush__yaar Жыл бұрын
mind blowing!
@GyanOnTube
@GyanOnTube Жыл бұрын
Thank you so much
@ashoksahu9546
@ashoksahu9546 5 жыл бұрын
Nice video sir.
@GyanOnTube
@GyanOnTube 5 жыл бұрын
Ashok sahu :- stay tune with my channel mote videos to come.
@rituparnadas190
@rituparnadas190 Жыл бұрын
Would you be available to provide one on one virtual sessions for courses on Power BI, Power Apps, SQL and other Data Analytics Tool?
@GyanOnTube
@GyanOnTube Жыл бұрын
Yes definitely i can..you can connect me by checking description column below
@mdmasum-uh7zj
@mdmasum-uh7zj 4 жыл бұрын
Xlookup par phir se ak vedio banaye sir jii or search mode,match mode ka pura option samjhaye or example ka data jade rkhe sir jii
@GyanOnTube
@GyanOnTube 4 жыл бұрын
Ji bilkul md Masum ji..mene iske uper ek detail video banaii hai..ye raha link kzbin.info/www/bejne/pH_Wo2x7d5mVZ9k
@pranaychhibbar6111
@pranaychhibbar6111 2 жыл бұрын
Sir, Can't we use lookup function instead of vlookup because lookup function allows us to search the value both ways i.e left to right and right to left
@GyanOnTube
@GyanOnTube 2 жыл бұрын
You can use xlookup if you have latest office365
@pranaychhibbar6111
@pranaychhibbar6111 2 жыл бұрын
@@GyanOnTube Sir, What is the limitation in lookup function ?
@GyanOnTube
@GyanOnTube 2 жыл бұрын
Its not dynamic
@KavyaPawar1
@KavyaPawar1 Жыл бұрын
Dear Sir pls tell how to record lowest & highest value of continue change cell value in particular cell..
@GyanOnTube
@GyanOnTube Жыл бұрын
Please elaborate
@kartavyatiwari8583
@kartavyatiwari8583 3 жыл бұрын
Sir aap konsa screen recorder use krte hai...or agar aap OBS use krte h to Fir jo Red marker se highlight kr rhe h wo kaise kr rhe h... except this question your video is awesome sir Lekin sir mere questions ka rply zarur kre
@GyanOnTube
@GyanOnTube 3 жыл бұрын
Bahut saari application hai..online aapko mil jaayegi..
@kartavyatiwari8583
@kartavyatiwari8583 3 жыл бұрын
@@GyanOnTube sir kya aap OBS se records krte h...or agar krte h..to Plz bataiye wo red marker kaise laate h recoding k time.. qki wo alag edit kiya hua nhi h
@enlightenment9704
@enlightenment9704 2 жыл бұрын
Check out this video link kzbin.info/www/bejne/f3Tahp58rryKg7M
@jitheshkollambi7296
@jitheshkollambi7296 3 жыл бұрын
Please tell me how to get outstanding amounts which I can formula use it.
@GyanOnTube
@GyanOnTube 3 жыл бұрын
Outstanding amount for what
@jitheshkollambi7296
@jitheshkollambi7296 3 жыл бұрын
@@GyanOnTube I want to find out paid and not paid amount in monthly statement
@GyanOnTube
@GyanOnTube 3 жыл бұрын
Do you have a sheet in which you want to find
@vandnasoni7851
@vandnasoni7851 5 жыл бұрын
Sir xlookup ko download version Microsoft office 2019 me kab se or ksise use kar sakte hai Office 2019 me ye formula kab Tak aa jayaga please sir bataye
@GyanOnTube
@GyanOnTube 5 жыл бұрын
Abhi Microsoft ne ye sirf office insider mein release kiya hai..aur 3 se 4 mahine lagenge office 2019 mein aane mein..abhi ye testing face mein hai..
@mdmasum-uh7zj
@mdmasum-uh7zj 4 жыл бұрын
Same question sir mera vi hai hmko pta kaise chrlga sir jiiii ye office 2019 me aa gya
@shoyebkhan4801
@shoyebkhan4801 2 жыл бұрын
Sir agar humko multiple column ka data lena ho to xlookup se kaise lege
@GyanOnTube
@GyanOnTube 2 жыл бұрын
Uske liye aapko jitne bhi column chaiye select all...
@shoyebkhan4801
@shoyebkhan4801 2 жыл бұрын
@@GyanOnTube ok sir will try or confirm you and thx
@GyanOnTube
@GyanOnTube 2 жыл бұрын
Thank you so much
@shakirnadeemnadeem4620
@shakirnadeemnadeem4620 4 жыл бұрын
I want to search duplicate name value show by xlookup
@GyanOnTube
@GyanOnTube 4 жыл бұрын
Very nice question shakir ji..you can use one other formula..check this video. kzbin.info/www/bejne/rIfCYmCQnN2snqc
@arya2607
@arya2607 Жыл бұрын
mere excel me wild character ahe nahi raha hai
@GyanOnTube
@GyanOnTube Жыл бұрын
Which Excel version you are using
@mercifulkhan9796
@mercifulkhan9796 3 жыл бұрын
How to get free 365 office want to learn
@GyanOnTube
@GyanOnTube 3 жыл бұрын
As of now office 365 is not free.. however in future you might get it for free..
@mercifulkhan9796
@mercifulkhan9796 3 жыл бұрын
Power query and power bi it’s same
@GyanOnTube
@GyanOnTube 3 жыл бұрын
Not at all...bahut fark hai dono mein...zameen aur assman ka...
@mercifulkhan9796
@mercifulkhan9796 3 жыл бұрын
Toh muje kaun se learn kar na chaiye jada power bi or power query main Thoda confuse hoon
@GyanOnTube
@GyanOnTube 3 жыл бұрын
@@mercifulkhan9796 aaj kal companies sirf power BI ki demond kar rahi hai...so learn power bi only
Sigma baby, you've conquered soap! 😲😮‍💨 LeoNata family #shorts
00:37
They Chose Kindness Over Abuse in Their Team #shorts
00:20
I migliori trucchetti di Fabiosa
Рет қаралды 10 МЛН
Yay, My Dad Is a Vending Machine! 🛍️😆 #funny #prank #comedy
00:17
Walking on LEGO Be Like... #shorts #mingweirocks
00:41
mingweirocks
Рет қаралды 4,9 МЛН
How to Use Macro in Excel in Hindi
15:50
Deepak EduWorld
Рет қаралды 1,5 МЛН
Learn POWER QUERY step by step in Hindi - Advance Excel
50:02
Sigma baby, you've conquered soap! 😲😮‍💨 LeoNata family #shorts
00:37