I am trying to do a vlookup for a one to many relationship but I am having a hard time figuring out the right formula. I have two tables.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
I want to be able to pull the service code and description from table two into table one based on ID.
Does anyone have any ideas of how I can do that easily?
Thanks!
Table 1
ID | Description |
1 | Blue |
2 | Green |
3 | Yellow |
4 | Orange |
5 | Aqua |
6 | Red |
<tbody>
</tbody>
Table 2
Service Code | Description | Id |
111 | Orange | 4 |
112 | Orange Mixed | 4 |
113 | Yellow | 3 |
<tbody>
</tbody>
I want to be able to pull the service code and description from table two into table one based on ID.
Does anyone have any ideas of how I can do that easily?
Thanks!