Data Entry by MARIA

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).

I am available for
Excel data Entry

A sample cv design by me

INVOICE
it allows for easy customization, enabling users to tailor invoices to reflect their brand identity with logos and specific layouts.

🌟 Welcome to our page! 🌟

We’re thrilled to have you here! This is a space where we share exciting updates, inspiring content, and connect with all of you. Your support means the world to us, and we can’t wait to engage with you through posts, comments, and messages.

Feel free to introduce yourself, share your thoughts, and join the conversation. Together, let’s create a vibrant community!

Thank you for being a part of our journey! 💖

Send a message to learn more