Dear Excel Experts, In Sheet 2, vlookup formula has been applied to obtain emp codes from sheet 1. However, unable to copy same formula to obtain DOJ. Please find sheet attached and help to resolve.
From India, Delhi
Acknowledge(0)
Amend(0)
24From India, Delhi
Acknowledge(0)Amend(0)
You are using the wrong table reference for the lookup. Since you are performing a VLOOKUP based on the Emp code, the table should start from the Emp code column and include the DOJ column in the reference table. The lookup table's first column should contain the value on which you are performing the search. The correct formula would be:
=VLOOKUP(C2, Sheet1!$C$2:$D$51, 2, 0)
From India, Delhi
Acknowledge(0)Amend(0)
=VLOOKUP(C2, Sheet1!$C$2:$D$51, 2, 0)
From India, Delhi
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.
Excel Formula for Last Week Date.jpg
EXCEL FORMULA.xls