Create a new column using data from 2 other related tables

[adoster]

I have 3 related tables. I am trying to create a new column based on values from the other 2 tables.

Table A

Name	Old Code
Mickey Mouse	11111
Donald Duck	11111
Iron Man	22222
Captain America	33333
Black Widow	44444
Iron Man	55555

Table B

Original Code	New Code
11111	12345
22222	23456
33333	34567
44444	45678
55555	56789

Table C

Name	Type	Code
Mickey Mouse	Disney	77777
Donald Duck	Disney	77777
Superman	DC Comics	88888
Iron Man	Marvel	See Table B
Captain America	Marvel	See Table B
Black Widow	Marvel	See Table B

Something similar to:

IF ('Table C'[Type] = "Marvel" THEN 'Table B'[New Code]) ,  ELSE 'Table C'[Code]

Here are the reulst for these sample Tables

Name	Original Code	NEW Code Results
Mickey Mouse	11111	77777
Donald Duck	11111	77777
Superman	22222	88888
Iron Man	22222	23456
Captain America	33333	34567
Black Widow	44444	45678
Iron Man	55555	56789

[Greg_Deckler · Accepted solution]

@adoster Maybe:

Column = 
  IF (RELATED('Table C'[Type]) = "Marvel", RELATED('Table B'[New Code]),RELATED('Table C'[Type]))