Hello,
I have the following scenario where I want to match the two columns in
Sheet1, with the columns Code and State in Sheet2, but list the Branch found
in Sheet2.

I would like the Branch to populate a column in Sheet1.

Thanks for your help.

Sheet1:
Ref State
0 CA
0 FL
0 MD
13 NV
144 TX


Sheet2:
Code Branch State
0 NJP33 NJ
13 NVP22 NV
144 TXP62 TX