VLOOKUP anamoly?

How can a VLOOKUP work fine in one column (C) of my worksheet but returns a #REF! error in another(F)?  Using data from another sheet in the workbook, I compile a monthly report for billing. However,...