From what I see, you are having a problem with the formula in E7. I found a problem with the construction of the first VLOOKUP. The column that you want to return a value from is 5 but that is outside the ARRAY that you have defined for the VLOOKUP. Column 1 is the column where the value is that is being looked up. Go through all your VLOOKUP statements and be sure that the column that you want to retrieve a value from is in the array defined for the VLOOKUP. Column P doesn't have values in it and if it is to remain empty, delete it. Taking a quick look at the rest of the formula, all the VLOOKUPs that have 5 as the column, are incorrect, being outside the ARRAY for the lookup. So redefine the ARRAY and adjust the column numbers that you want to retrieve data from.


Concerning A3 question: Where you want the answer enter this formula:

Formula: copy to clipboard 
=VLOOKUP(A3,K5:L12,2,1)