Formula for Capitalization

[Beh162]

A1	Bob(B1)
	Mary (B2)
	Nina
NINA (A4)

<tbody>
</tbody>

I'm wondering if there is a formula that is available that will search B1:B3 and if it matches A4 (NINA) it will then anything in Column B that matches to uppercase or to mirror A4.

So I'd want it to then change it to look like this:

A1 Bob(B1) Mary NINA NINA (A4) <tbody> </tbody>

<tbody>
</tbody>

I know it seems odd, but rather than having to manually type the matches, I was wondering what formula's may be available.

 

[mrmmickle1]

Try doing a vlookup....If there is a hit then we will now capitalize it.... if not then it says "No Match"

=IF(ISERROR(VLOOKUP(A4,B1:B3,1,FALSE)),"No Match",UPPER(VLOOKUP(A4,B1:B3,1,FALSE)))