In Turkish Excel: =YATAYARA(aranan_değer; tablo_dizisi; satır_indis_sayısı; [aralık_bak])
Argument
Description
lookup_value
The value to find in the first row.
table_array
The range to search.
row_index_num
The row number within the range to return.
[range_lookup]
FALSE for an exact match.
HLOOKUP 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
=HLOOKUP("Quantity",A1:D6,3,FALSE)
Result: 8
Returns the value in the 3rd row under the "Quantity" header.
Results were calculated in real Excel.
Tips for HLOOKUP
If your headers are in a column rather than a row, use VLOOKUP.
Related functions
More formula guides
More tools
About HLOOKUP Function
The horizontal version of VLOOKUP: searches the first row of a table and returns a value from a row you specify in the same column.
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 HLOOKUP Function
Type the formulaStart typing =HLOOKUP( 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 HLOOKUP in Turkish Excel?
In Turkish Excel, HLOOKUP is called YATAYARA. Turkish Excel also separates arguments with semicolons (;) instead of commas.
Which Excel versions have HLOOKUP?
HLOOKUP is available in all current Excel versions (2010 and later, Microsoft 365).