We have two excel files , they have the common filed ( student ID ) , I would like to join the tables so that the output as below table ( after vlookup ) , would advise what can I do ? thanks
Table 1
| student ID | Student Name |
|---|---|
| 001 | Peter |
| 002 | Tom |
| 003 | Mary |
Table 2
| student | ID | Class |
|---|---|---|
| 001 | Form | 1 |
| 002 | Form | 2 |
| 003 | Form | 3 |
After vlookup()
| student ID | Student Name | Class |
|---|---|---|
| 001 | Peter | Form 1 |
| 002 | Tom | Form 2 |
| 003 | Mary | Form 3 |
