I have a chemical inventory list where there are specific chemicals where
this formula =VLOOKUP(A2,Sheet2!$A$2:$C$224,2,FALSE) brings over the
chemical name in all capital letters to sheet 1.
If I format the capitalized chemical names in the VLOOKUP sheet2 with bold
and italics the formatting is dropped when brought over to the formula cell.
How can I bold and italic only the chemical names that are capitalized?

Thanks