Dear seniors I found error whenever i use vlookup command so please provide me exel sheet with used these commands Regards Praveen
From India, New Delhi
Acknowledge(0)
Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
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
From India, Ahmadabad
Acknowledge(0)Amend(0)
89Regards,
Hardik
From India, Ahmadabad
Acknowledge(0)Amend(0)
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
From India, Ahmadabad
Acknowledge(0)Amend(0)
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
From India, Ahmadabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Advanced Excel 2003.pdf
Competancy--exc el---mts___smts _289.xls
Excel for construction.zi p