Struggling with VLOOKUP in Excel? Can You Share a Working Example Sheet?

Dear seniors, I have found an error whenever I use the VLOOKUP command. Could you please provide me with an Excel sheet that demonstrates the use of these commands?

Regards,
Praveen

Hi Praveen, please look after the link below: https://www.citehr.com/397346-excel-...ml#post1810329. If you have any problems, feel free to ask.

Regards,
Hardik

Whenever you have to match the column records of two sheets, VLOOKUP can be useful for the same. It can be used as follows:

Sheet 1:

Column A
Clmn. A: Name Clmn B: Age
A =VLOOKUP(A1, Sheet2!A1:C3, 3, 0)
B
C

Sheet 2:

Clmn. A: Name Clmn B: DOB Clmn C: Age
C
B
A

Explanation:

VLOOKUP(A1, Sheet2!A1:C3, 3, 0)
- A1:C3 = Existing Sheet range, based on which details, required data should be retrieved.
- Sheet2: Select the sheet from where you need to fetch the data.
- A1:C3: Entire Range from where data should be fetched (A=Name, B=DOB, C=Age).
- 3: Number of the column where the data is mentioned (i.e., Age).
- 0: Default

It's confusing, but you may try.

Thanks,
Ankita

I have attached a file regarding VLOOKUP. Kindly find the enclosed attachment. The file "A" contains old data, which we have transferred from file A to file B using VLOOKUP.

Regards,
Hardik Bhavsar
HR Coordinator

Dear Praveen,

Find the attached Excel file.

Regards,