VLOOKUP HELP! Monster Formula not working.

You are exactly right.  The formula is looking for the exact phrase, and since your new system uses different wording, it can't find the info, and if one of the instances of VLOOKUP returns N/A, then the entire formula returns NA.  This workbook has a lot of hidden sheets, and one of them is called Lookup Tables.  If you right click on a tab, and select unhide, then select Lookup Tables, you will see 8 separate tables listed. In each table, the first column is what the formula is looking for, and the second column is what it would display.  The first column should contain the values as they appear in your raw data, the second column, would be what is displayed in your output sheet.  You will have to go through each table, and replace the values in the first columns with what your raw data displays now.  Keep in mind, these are tables.  You can tell by the filled in corner at the bottom right cell of each.  If you need to add a new row to the table, select the bottom right cell, and press tab