Need VBA Code to "VLOOKUP" but keep source cell Formatting

Hello all,

I'm new to the forum and am needing some help. Attached is a VERY simple spreadsheet with Animals on Sheet1 and a table on Sheet2, also with the same animal names, but corresponding colors (each with different formatting). I know there is no way for the VLOOKUP to output the format of the source, so I'm looking for a VBA code to Find the matching Animal from Sheet1, on Sheet2, then output the Formatted Corresponding color back to Sheet 1, adjacent to that animal. For example,

Lookup Sheet1, A3 ("Lion") on Sheet2, A2:B5, then output Sheet2, B5 (Red) to Sheet1,B3.

I am using Excel 2003, but have the ability to use 2007 if needed. Thank you for your time.