hii @Jorgie
You can use this and find if your problem is sloved
=VLOOKUP(B2, [EmployeeGrossSalaryFile.xlsx]Sheet1!$A$2:$Z$100, 3, FALSE)
Have one more solution for multiple months ill share that as well
=VLOOKUP(B2, [EmployeeGrossSalaryFile.xlsx]Sheet1!$A$2:$Z$100, MATCH(“Gross Salary (JAN 2024)”, [EmployeeGrossSalaryFile.xlsx]Sheet1!$A$1:$Z$1, 0), FALSE)