Formula for Capitalization

[Beh162]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]Bob(B1)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mary (B2)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Nina[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NINA (A4)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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:
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]Bob(B1)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mary[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]NINA[/TD]
[/TR]
[TR]
[TD]NINA (A4)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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)))