Please help. Cant get index and match to work :(
<tbody>
</tbody>
<tbody>
Location
Old Code
New Code
A
AVR
=INDEX(Table2,MATCH([@Old Code],Table2[#All],0),8)
N
VVB
G
XX
W
YY
p
9S
C
RCM1M
T
H
</tbody>
Table 2:
<tbody>
A
N
G
W
P
C
T
New Code
ABB
PPS
2PL
AB
APB...