How can I alter this formula so I do not get a #N/A in a cell if no value is returned? I am trying to average the column and it throws it off.

Here's my current formula:

=VLOOKUP("boston",'1.26.05'!$A$1:$B$50,2,FALSE)

I would appreciate any help I could get.

Thanks,

Chris