Thanks for the response, however, i get an error message when i attempt to
input this formula. The "" are hightlighted from the error message
indicating that the error is within the portion of the formula. I have also
attempted to replace the "" with simply an 0 and other inputs but I still
receive the error message. Am I missing something with the input?

"Pete_UK" wrote:

A better way of avoiding the #NA error is to use ISNA, as follows:

=IF(ISNA(VLOOKUP(B9,Q12:R41,2,0),"",VLOOKUP(B9,Q12 :R41,2,0))

This will return a blank (i.e. "" in the middle of the formula) instead
of #NA - you might like this to be zero (i.e. 0 without quotes in the
middle of the formula).

Hope this helps.

Pete