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