What is The XMatch Function in MS Excel in Hindi | XMatch in Office 365 in Hindi

#XMatch #Xlookup #HelloAnalyst

Hello Analyst,

I this video You will learn #Xmatch function in Office 365 in Hindi Language

XMatch Introduction.

lookup_value – the value you want to search;
lookup_array – the range or array where you want to search the value;
[match_mode]
0 – Exact Match (if no result found, then error)
1 – Exact or next smaller (if no result found, then the next smaller value will be displayed)
2 – Exact or next larger (if no result found, then the next larger value will be displayed)
3 – Wildcards
[search_mode]
1 – to search from first
-1 – to search from last
2 – binary search ascending
-2 – binary search descending

Example covered in this Video.
1-Vertical XMATCH
2-Horizontal XMATCH
3-Exact match vs. approximate match
4-Partial match with wildcards
5-Reverse search
6-INDEX XMATCH formula
7-INDEX XMATCH XMATCH formula
8-Case-sensitive XMATCH formula

Xmatch Video link.

   • How to Use XLOOKUP in Excel in Hindi ...  

Search Keywords,
#Index #Xmatch #Xlookup

vba excel programming
vba excel
VBA excel
vba in excel
EXCEL
Excel
data analysis excel
excel pivot tables


Thanks,
Happy Learning!