Removing #N/A

**shiftyspina** · 06-12-2013, 09:21 AM

Hi All

I got this code from browsing around the web looking for an answer.....

Please Login or Register  to view this content.

What i want is for the code to remove any #N/A cells in my sheet, i have used a index and match formula to look up values for me, and it returns a lot of #N/As but because this sheet can change at any time i dont want to delete out the #N/As i want the formula to stay in the cells, but cant build in an isna or iserror formula with the index and match formula.

Basically i want this code to turn any #N/As in the worksheet to 0 or - but only by clicking the command button?

Would anyone know how this can be done?

Dan

**AB33** · 06-12-2013, 09:23 AM

Use Iferror function with your formula

**shiftyspina** · 06-12-2013, 09:29 AM

ok il give that a go thanks

**AB33** · 06-12-2013, 09:59 AM

May also be

Please Login or Register  to view this content.

**jevelvel** · 06-15-2013, 07:06 PM

Hi,

Can you help me with how to use remove n/a to my vlookup formula?

My formula is =VLOOKUP(C100,'MCS Agents list'!$D$5:$G$23,2,1)....

pleeeeeeese!!!!!!!!!!!!!!!

**FDibbins** · 06-15-2013, 07:13 PM

Hi jevelvel and welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**shiftyspina** · 06-15-2013, 07:25 PM

Try.....

Formula:

Please Login or Register  to view this content.

Or

Formula:

Please Login or Register  to view this content.

**jevelvel** · 06-15-2013, 07:30 PM

thanks!

**FDibbins** · 06-15-2013, 07:42 PM

shiftyspina...
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc