Data Entry by MARIA

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

13/04/2025

Follow me for data entry services

13/04/2025

I am available for
Excel data Entry

05/04/2025

Daily attendance sheet in Ms Excel
Feel free to contact me all kinds of data entry
Here I am on fiverr 👇👇

https://www.fiverr.com/s/BR39Z87

29/03/2025

A sample cv design by me

29/03/2025

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

29/03/2025

🌟 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