Assume I have Table A with 'Employee ID' in column A and Table B with 'Employee ID' in column D and 'Salary' in column E. Write a formula (using XLOOKUP or INDEX/MATCH) to pull the correct salary from Table B into Table B for each ID in Table A.