All solutions FormulaVLOOKUP Expert Solution – How to Use a VLOOKUP Formula

Excel - How to Use a VLOOKUP Formula - Expert Solution

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
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc