Excel XLOOKUP Function: How to Use It, with Examples Turkish: ÇAPRAZARA
The modern, flexible successor of VLOOKUP: you pick the lookup column and return column separately, it can look left, and you can set a message for missing values. Available in Excel 2021 and Microsoft 365.
In Turkish Excel: =ÇAPRAZARA(aranan_değer; arama_dizisi; döndürülen_dizi; [bulunamazsa])
Argument
Description
lookup_value
The value to search for.
lookup_array
The single column or row to search.
return_array
The column or row to return from.
[if_not_found]
Text or value to return if nothing is found.
XLOOKUP examples
Sample table:
A
B
C
D
1
Product
Region
Quantity
Price
2
Pen
Ankara
12
5
3
Notebook
İzmir
8
20
4
Eraser
Ankara
30
2
5
Notebook
Ankara
5
20
6
Pen
İzmir
7
5
=XLOOKUP("Eraser",A2:A6,D2:D6)
Result: 2
Returns the price of Eraser.
=XLOOKUP("Ruler",A2:A6,D2:D6,"None")
Result: None
Returns "None" instead of an error when the value is missing.
Results were calculated in real Excel.
Tips for XLOOKUP
Exact match is the default, so there is no FALSE to forget.
Not available in Excel 2019 and earlier; use INDEX + MATCH when sharing files with older versions.
Related functions
More formula guides
More tools
About XLOOKUP Function
The modern, flexible successor of VLOOKUP: you pick the lookup column and return column separately, it can look left, and you can set a message for missing values. Available in Excel 2021 and Microsoft 365.
Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.
How to use XLOOKUP Function
Type the formulaStart typing =XLOOKUP( in a cell; Excel shows the arguments.
Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
Press EnterCheck the result; you can also try it in the tester below.
Frequently asked questions
What is XLOOKUP in Turkish Excel?
In Turkish Excel, XLOOKUP is called ÇAPRAZARA. Turkish Excel also separates arguments with semicolons (;) instead of commas.
Which Excel versions have XLOOKUP?
XLOOKUP is available in Excel 2021 and Microsoft 365.