Excel VLOOKUP Function: How to Use It, with Examples
Turkish: DÜŞEYARA

Looks up a value in the first column of a table and returns a value from another column in the same row. It is the classic way to find a price by product code or a name by employee ID.

VLOOKUP syntax

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

In Turkish Excel: =DÜŞEYARA(aranan_değer; tablo_dizisi; sütun_indis_sayısı; [aralık_bak])

ArgumentDescription
lookup_valueThe value to search for in the first column.
table_arrayThe range to search; the lookup value must be in its first column.
col_index_numThe column number (within the range) to return the value from; the first column is 1.
[range_lookup]FALSE (0) for an exact match. If omitted, an approximate match is used and the first column must be sorted.

VLOOKUP examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=VLOOKUP("Eraser",A2:D6,4,FALSE)
Result: 2

Returns the price (column 4) of Eraser.

=VLOOKUP("Notebook",A2:D6,3,FALSE)
Result: 8

With duplicates it returns the first matching row.

Results were calculated in real Excel.

Tips for VLOOKUP

  • Always use FALSE as the 4th argument for an exact match; leaving it out is the most common mistake.
  • VLOOKUP cannot look to the left; use INDEX + MATCH or XLOOKUP instead.
  • #N/A means the value was not found; wrap the formula in IFERROR to show your own message.

Related functions

More formula guides

More tools

About VLOOKUP Function

Looks up a value in the first column of a table and returns a value from another column in the same row. It is the classic way to find a price by product code or a name by employee ID.

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 VLOOKUP Function

  1. Type the formulaStart typing =VLOOKUP( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is VLOOKUP in Turkish Excel?

In Turkish Excel, VLOOKUP is called DÜŞEYARA. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have VLOOKUP?

VLOOKUP is available in all current Excel versions (2010 and later, Microsoft 365).