The vlookup is like this (using you example)
=VLOOKUP(B2, $C$1: $E$4, 1, FALSE)
look at value B2
Match it at column C (the first column in $C$1: $E$4) decide which column to match against. If a match is found, then it will return the first column in range (C1 to E1, which basically means column C)
False means make an exact match
If no match is found, the functin will return errror like #N/A
It is hard to tell how your data is laid out as formatting is lost.
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like http://www.speedyshare.com/
, http://docs.google.com, http://wikisend.com/
post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
your data need not be to be real data but a good representative of how data looks like