When vlooup found two similar values, it always get the first one.
I have the same two values in File 1 but two have two different equivalent
values in File 2

File 1 File 2

Site A Site A=Primary
Site A Site A=Secondary

Results
Site A = Primary
Site A = Primary ? Should be = Secondary

How could I make a formula that the second value should be the also the
second value found in File 2.

Thanks.