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
