Excel 2007. I cannot seem to get this formula to work:

=IF(AND((VLOOKUP(CONCATENATE(TRIM($A29),TRIM($A$27 )),'test
(083)'!$J:$L,3,FALSE)=C$28),(VLOOKUP(CONCATENATE( TRIM(A29),TRIM($C$27)),Overrides!$E:$F,2,FALSE)<" N")),"Y"," ")

I am trying to do an if statement to enter a "Y" or blank based on my AND
parameter. The first AND logical test is checking to see if the vlookup
number is greater than the number in cell C28 which is a number 4. This part
of the formula seems to work as I tested it by itself. It is the second
logical test that doesn't seem to work. I only want to enter a "Y" in the
cell if my vlookup number is greater than a 4, which it is ,and also if the
cell matching the vlookup is equal to a "N". If so enter a Y, and if not
enter a blank. The cell that matches has a "N" in it so a Y should be
entered based on my formula. I just one blank cell (the first one) and the
rest are cells with "#N/A" based on cells with my formula.