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
23From India, Delhi
please give the details of the other sheet from were you are trying to capture details
From India, Chennai
From India, Chennai
You are using wrong table reference for lookup. As you are doing vlookup on the basis of Emp code, so your table should start from Emp code column and include DOJ column in reference table. Lookup table's first column should include the value based on which use are doing search. Correct formula would be :
=vlookup(C2,Sheet1!$C$2:$D$51,2,0)
From India, Delhi
=vlookup(C2,Sheet1!$C$2:$D$51,2,0)
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Copy of Puzzle(1).xls
Bonus act amendment gazette copy.pdf