MICROSOFT EXCEL CELL FORMAT

IS IT POSSIBLE TO RETURN THE RESULT OF A FORMULA IN THE EXACT FORMAT FROM THE CELL IN WHICH THE ANSWER WAS DERIVED FROM? MY SITUATION IS AS FOLLOWS, I HAVE A TABLE SET UP THAT CONTAINS BOTH NUMERIC AND ALPHA CHARACTERS. IN THE TABLE, THE CHARACTERS THAT ARE ALPHA ARE FORMATTED IN RED. EXAMPLE, S16 APPEARS WITH THE “S” IN RED AND 16 IN BLACK (I SIMPLY HIGHLIGHTED THE LETTER “S” IN THE FORMULA BAR AND SELECTED THE FONT COLOR RED). WHEN I PERFORM A VLOOKUP FUNCTION, I WANT THE RESULT TO APPEARTHE EXACT SAME WAY, I.E I WANT THE “S” TO BE RED, AND THE NUMBER 16 TO BE BLACK.

IS THIS POSSIBLE? HELP!!