I have good knowledge of Excel, but I am facing a problem. I have prepared Employees' PF Deduction records month-wise in compiled Sheet A, and in Sheet B, I have created a standard format of Form-3A with all details, linking it with a command lookup. The lookup value is the Employee PF No. When I input the employee PF No. in the selected column, all the details month-wise appear in the sheet with names, Father's Name, etc. However, in some cases, it's not showing the correct data from Sheet A. When we change the PF No. of any employees, in some cases, it's not changing the value. Please help me with other commands so I can get the correct data with this link.
For more clarification, please contact me.
Regards, Vishwash Thakur
[Phone Number Removed For Privacy Reasons]
From India, Mumbai
Acknowledge(0)
Amend(0)
2For more clarification, please contact me.
Regards, Vishwash Thakur
[Phone Number Removed For Privacy Reasons]
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Vishwash, please freeze the table array (select the table array and press F4) while using VLOOKUP. Please note that when you use the VLOOKUP function in the same worksheet, you need to freeze the table array. For example: +VLOOKUP(lookup_value, table array, col_index_num, range_lookup). Press F4 after selecting the table array. Hope this helps you.
Thanks & Best Regards,
Prem Singh Rawat
[Phone Number Removed For Privacy Reasons]
From India, Delhi
Acknowledge(0)Amend(0)
Thanks & Best Regards,
Prem Singh Rawat
[Phone Number Removed For Privacy Reasons]
From India, Delhi
Acknowledge(0)Amend(0)
Thank you for your reply. I have already completed all the tasks. I believe you may not have understood my point. There are instances where I do not receive the correct response when I enter the PF number. I think there is a need for a macro or a security level case; otherwise, I do not see a solution.
Regards, Vishwash Thakur
Dear Dasrp, You can send your sheet to me at [Email Removed For Privacy Reasons].
From India, Mumbai
Acknowledge(0)Amend(0)
Regards, Vishwash Thakur
Dear Dasrp, You can send your sheet to me at [Email Removed For Privacy Reasons].
From India, Mumbai
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.
10 ways to format Excel data.pdf
Payroll Data Format in Excel.xls