**Question description:**

*This user has given permission to use the problem statement for this blog.*

Excel formula returns a lot of #N/A results but unsure how to incorporate the IFERROR function to remove them, Can anybody help?
=IF($A3="","",IF(VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE)="","",VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE)))
I have removed the link to the sharepoint doc as it gives away the company name so where it says 'SHAREPOINT LINK' just ignore, I don't think anyone needs to know that info. to get the formula to work.
Thanks in advance to anyone able to help.

Solved by X. E. in 5 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
14/09/2018 - 10:52

Hello there! I understand that you need help with an IFERROR function to remove the #N/A, right?

User
14/09/2018 - 10:52

yes please

Excelchat Expert
14/09/2018 - 10:52

Alright, I can help you with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.

Excelchat Expert
14/09/2018 - 10:52

I may have a few quick question to help me fully understand your requirement.

User
14/09/2018 - 10:52

ok, no problem

Excelchat Expert
14/09/2018 - 10:53

The formula works properly, right? The only thing missing is the error check?

User
14/09/2018 - 10:53

yes

Excelchat Expert
14/09/2018 - 10:53

Okay, to properly add the iferror() function, insert this just after the = and before the first IF

Excelchat Expert
14/09/2018 - 10:53

iferror(

Excelchat Expert
14/09/2018 - 10:53

Then at the very end of the formula, type:

Excelchat Expert
14/09/2018 - 10:53

,"")

Excelchat Expert
14/09/2018 - 10:54

So it'll result to :

Excelchat Expert
14/09/2018 - 10:54

=iferror(IF($A3="","",IF(VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE)="","",VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE))),"")

Excelchat Expert
14/09/2018 - 10:54

Of course, you can change the "" to anything you want.

User
14/09/2018 - 10:54

that's done it, you my friend are a star

Excelchat Expert
14/09/2018 - 10:55

Glad to have helped!

Excelchat Expert
14/09/2018 - 10:55

Would there be anything else that I can help you with regards to the original question?

User
14/09/2018 - 10:55

no tats all I needed, you help is very much appreciated

Excelchat Expert
14/09/2018 - 10:55

Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.

Excelchat Expert
14/09/2018 - 10:55

I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.

Excelchat Expert
14/09/2018 - 10:55

Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.

User
14/09/2018 - 10:55

you do and I will

Excelchat Expert
14/09/2018 - 10:55

Thank you I'd appreciate that. It would help me a lot.

Excelchat Expert
14/09/2018 - 10:56

Please do not forget to click the End Session button so you can rate me.

User
14/09/2018 - 10:56

thanks again