Vlookup producing "#n/a"


G

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.
 
Ad

Advertisements

G

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top