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
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
Copy of Puzzle(1).xls
Bonus act amendment gazette copy.pdf