Avoiding #N/A

G

gibbylinks

Hi, I use a spreadsheet for invoicing and have a product code entered into a
column when a product (in column C) is selected.

I also sometimes use this column to put a description in rather than pick a
product.

Can my formula be modified to avoid the #N/A appearing in the product code ?

Current formula is

=IF(C25<>"",VLOOKUP(C25,Product_Data,2,FALSE)," ")

Thanks
 
B

Bob Phillips

Try

=IF(C25<>"",IF(ISNA(VLOOKUP(C25,Product_Data,2,FALSE)),"",VLOOKUP(C25,Product_Data,2,FALSE)),"
")

HTH

Bob
 
V

Vital_ar

Hi,
If your want to just remove the #N/A, then try to use Iserror function like
this,

=IF(ISERROR(IF(C25<>"",VLOOKUP(C25,product_data,2,FALSE),"
")),"-",IF(C25<>"",VLOOKUP(C25,product_data,2,FALSE)," "))

It will return - in that respective sell.

Regards,
 
×

מיכ×ל (מיקי) ×בידן

Wouldn't that be shorter ?
=IF(ISNA(VLOOKUP(C25,product_data,2,)),"-",VLOOKUP(C25,product_data,2,))
Micky
 
×

מיכ×ל (מיקי) ×בידן

No doubt - but I, usually, try to focus on the questions - as is...
Micky
 
×

מיכ×ל (מיקי) ×בידן

If you'll look at the subject line of the question and/or read' again, its
content
:
"Can my formula be modified to avoid the #N/A appearing in the product code ?"
This is what my reply referred to.
Does the above answer your question.
I'm sure that if you would see a suggestion to add 5 cells - like:
=A1+B1+C1+D1+E1 you would also comment that this can be shorten to:
=SUM(A1:E1)
Please take into consideration that my English is not good enough to argue
so, please, do not push me into such.
Micky
 
B

Bob Phillips

I was supporting your original intervention within this thread by pointing
that no only is ISNA shorter then ISERROR, it is a better solution IMO. You
decided to take umbrage with that so nothing answers my question as I didn't
ask a question, and I don't care to get into arguments with people who get
stroppy with those who endorse their comments.

Bob

????? (????) ????? said:
If you'll look at the subject line of the question and/or read' again, its
content
:
"Can my formula be modified to avoid the #N/A appearing in the product
code ?"
This is what my reply referred to.
Does the above answer your question.
I'm sure that if you would see a suggestion to add 5 cells - like:
=A1+B1+C1+D1+E1 you would also comment that this can be shorten to:
=SUM(A1:E1)
Please take into consideration that my English is not good enough to argue
so, please, do not push me into such.
Micky


Bob Phillips said:
Then in that case I question why you joined in at all.




.
 

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

Similar Threads


Top