Xlookup in excel in hindi ye video aapko xlookup kese use karte hai form start till end with Binary Search and Wildcard character match bataegi.
is video mein aap #Xlookup seekh sakte hai wo bhi hindi mein jo Microsoft ne abhi new formula launch kiya hai. xlookup bahut sare formula ko beat karta hai jese #Vlookup # IndexMatch and Hlookup.
#Xlookupinhindi mein aap Binary Search (Sorted ascending order) , Binary Search (Sorted descending order) , Search last to First , Search first to last jo ki hamare xlookup ke ander search mode mein aata hai..
aur match mode mein xlookup ke ander aapko milta hai Exact Match , Exact Match or Next Smaller Item , Exact Match or Next Larger Item Item and wildcard character match ye sab aap is video mein seekh sakte hai..
yaha par aap excel related tips and tricks seek sakte hai aur wo bhi hindi mein..aap se aap vlookup formula in hindi ko bilkul use nhi karenge balki aap xlookup in hindi ko use kareiye isse aap aapna kaam bahut jaldi kar sakte hai.
Time Stamps
00:40 intro how xlookup works / how many modes we have in xlookup
00:58 how to use exact match in xlookup
01:52 Exact Match or next smaller item in xlookup
03:13 Exact Match or next larger item in xlookup
04:12 wildcard character match in xlookup
06:42 Search first to last in xlookup
07:48 Search last to first in xlookup
09:19 Binary Search (Sorted Ascending) in xlookup
12:03 Binary Search (Sorted Descending) in xlookup
*****************************************************************
Download Link :- https://drive.google.com/file/d/1KtdWyUn-hTcM6NgCmTglcicGjtD3JdjX/view?usp=sharing
*****************************************************************
If you have any question feels free to comments on the comment box below. If you LIKE this video then thumbs-up below.
Share this video with your friends - /watch/wUx6oXVXjt9X6
Don't forget to subscribe my channel get more related video notification. SUBSCRIBE – /channel/UCe1jvhdJVdGaJAevPss-TVg?view_as=subscriber
*****************************FOLLOW ON*************************
Facebook :- https://www.facebook.com/Excelworldofknowledge/
Twitter - https://twitter.com/SohanDey3
Youtube- /channel/UCe1jvhdJVdGaJAevPss-TVg
Follow me on Instagram :- https://www.instagram.com/gyan_on_tube/
__________________________________________________________
How to use Xlookup in excel 😮 || xlookup formula in hindi 😮|| vlookup formula in excel :- /watch/AKZWz-MDKkhDW
XLOOKUP formula in excel || XLOOKUP V/S Vlookup formula in excel 😮 || New Formula Xlookup in hindi :- /watch/IrZgYiDiphPig
XLOOKUP in excel || No More INDEXMATCH formula || How to use Xlookup formula in hindi :- /watch/UOvlhj13ZIk3l
How to use Xlookup in excel || Hlookup formula in Excel in hindi || New Xlookup formula :- /watch/0tiSDVAxa9VxS
xlookup in excel in hindi || Xlookup A to Z in details || New Xlookup with Search Mode :- /watch/wUx6oXVXjt9X6
Xmatch formula in excel || Xmatch formula in excel in hindi || Xmatch with Index formula :- /watch/MRvQRXYsFmKsQ
Top 10 excel formulas 😮|| excel formulas and functions || excel functions and formulas :- /watch/0Lwb1VkbjG1bb
how to use xlookup in vba || how to use formula in vba excel || excel vba create function :- /watch/IlUcH_4hqbThc
Xlookup formula in excel || Xlookup function in excel || Xlookup formula in excel with example :- /watch/w1b4BE9rsNnr4
how to use xlookup in vba || how to use formula in vba excel || excel vba create function :- /watch/IlUcH_4hqbThc
**************************************(Gyan On Tube)*********************************
xlookup in excel in hindi