Vlookup and iferror formula question

I am writing a vlookup formula and I get a #NO MATCH Error. I want to remove the error and give a result of 0 which seems pretty straight forward.

The formula I wrote looks like this : =VLOOKUP(SO@row, {Machine File Oven A Range 1}, 9, false)

When I add the iferror formula it looks like this:

=IFERROR(=VLOOKUP(SO@row, {Machine File Oven A Range 1}, 9, false), 0)

The problem I am having is that now all of my results come through as 0 instead of the values that should be pulled. I am sure this is an easy fix, but I need some help. Am I writing the iferror formula in the wrong place? If anyone can help let me know.

Thanks!

Find more posts tagged with

Accepted answers

Paul Newcome

Remove the equals sign from immediately before the VLOOKUP function.

All comments

Paul Newcome

Remove the equals sign from immediately before the VLOOKUP function.

Steve Rowlison

Yes it worked! Thanks for the quick help, I should have asked much sooner.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.