Vlookup producing "#n/a"

[Guest]

hi there,

my equation is producing a "#n/a" as a result - I wish it to produce a "0"
or no response on the negative result as another cell is summing the
responses, and needs blanks cells instead of "#n/a". The equation is

=VLOOKUP(D27,countries,2,0)

"countires" = a table with a list of country names in column A and a 1 in
coloumn 2.

Thank you for you help with this.

 

[Guest]

wonderful thank you for the help!

Any chance you know how to fix the "automatic update of currency symbol"
post problem I have put up too - I know thats cheeky, but you're good!

Thank you once again!