Struggling with Excel Lookup Errors: How Can I Fix Incorrect PF Data Links?

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]

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]

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].

Hi Vishwash,

What Prem has said was correct. This does not have anything to do with an increase or decrease in your macro security. If you have any doubts, please post your sample Excel file, and we can see what you are trying to convey.