I am using the following formula to automatically fill in cells and have copied the formula to the entire column. The cells that I copied into return #NA. What can I add to this formula to cause the cells with no information to be blank.
Hope this makes sense.

=UPPER(VLOOKUP(A11,AGYNO!$A$1:$B$281,2))

Thanks