Typing in data from the keyboard in a given cell does not trigger the formula

[itsgrady]

Typing in data (a code with letters and numbers) from the keyboard in a given cell does not trigger the formula, but copying the data and pasting it in the cell from a spreadsheet does trigger the formula. It's a lookup formula that is triggered from copying the code in the cell, but not from typing the code.

 

[shinigamilight]

What's the formula like? What's the data like? What's the formatting of the cell? There might be something related to case sensitive or white space character or some spelling mistake.

 

[itsgrady]

This is the formula:

=IFERROR(IF(VLOOKUP($AG$7,School12,2,FALSE)="","No Data",VLOOKUP($AG$7,School12,2,FALSE)),"")

 

[shinigamilight]

Youre using the logical test vlookup = "", but vlookup can never give out blank it will always give out an error NA if it's not able to find the value, Try removing the error handler and then run the formula. And I see identical lookups in the logical test and false parameter.
Just run this and tell me what's the output.

=VLOOKUP($AG$7,School12,2,FALSE)

 

[Fluff]

vlookup can never give out blank

It can & will if the 2nd column is blank on the row that matches.