Excel Formulas not working

Looking for some help on this excel.  Previously VLookup was used and it work but now does not.  I do not understand why.   Here is what I am trying to achieve in the excel attached:   1.  The data...