This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi all, would someone be able to help me with an excel someone has developed for me I am getting a #name error
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Tell the developer that this function is not supported in your version of Excel.
Andreas.
Is this because the version of excel for OFFICE 365 is different?
If i was to save on a personal OneDrive rather than work could this solve the issue?
You do not have Excel 365:
https://support.microsoft.com/en-us/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff
Ask your developer to solve the problem. He will know if it is possible in your version to solve the result with a different formula.
Andreas.
Hi Andreas, I am using office 365 at work. This was made by a reddit user.
Do you know where i could find someone to fix it?
Luke,
If you really had Excel 365, the error wouldn't occur. If you disagree, you should clarify with your admin why you have such an old version that it doesn't work.
The place where you can find someone who can help you is here. Create a new post, tell us your Excel version. Make your file available with a public link that everyone can access, the link above doesn't work. Describe what the formulas should produce as a result.
Andreas.