Intermediate
VLOOKUP Alternative
Create a modern spreadsheet formula to merge data from two tables.
📝 プロンプトの内容
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.