如果觉得辅助列有点乱，可以稍微调整下列宽、对齐方式等。 使用 Vlookup 函数，匹配表 2 和辅助列 1 的数据。 K 列中显示为「#N / A」的单元格 ...

Microsoft Excel is one of the most useful programs ever developed in the history of computing. One function that anyone looking to master the spreadsheet program needs to know is VLOOKUP.