13/04/2025
The VLOOKUP formula in Excel is used to search for a value in the first column of a table and return a value in the same row from another column.
Syntax:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Explanation:
lookup_value: Jis value ko dhoondhna hai.
table_array: Table ya range jahan se data lena hai.
col_index_num: Kaunsi column se value return karni hai (number form).
range_lookup: TRUE for approximate match, FALSE for exact match.
---
Example:
If you have a table like this:
Formula:
=VLOOKUP(102, A2:C4, 3, FALSE)
Result: 60000 (It finds 102 in column A and returns the value from column 3, which is Salary)
---
Let me know if you want a practical example file or help switching to XLOOKUP (the newer and better version).