I have messed up one of my formulas and don't know how to fix it.

I have accidentally deleted one of my formulas and can't get it working again. Please help. I need to do a vlookup but I keep getting a no match error

=VLOOKUP(Project1, {Project Ref Number}, 1, false)

this is my formula, not sure what the problem is, unless there is something with the reference table. What I am doing is matching a project name to the project number off the reference sheet.

On the reference sheet project number is column 1, project name is column 2 and project manager is column 3.

I will also need to pull the project manager to another column but if figure if I can get this one working then the other will be easy.

The above is the request sheet.

this is the reference sheet that was imported from excel.

Thanks

Cindy

Find more posts tagged with

Accepted answers

Andrée Starå

Hi @Cindy Bowker,

Have you checked the Activity Log for information that might help you restore or see how it was working before?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Mike Wilday

I would test your assumptions about the reference sheet and make sure that's not the problem. You can edit the formula and click on the area with the cross-sheet reference, then click edit reference to make sure its still and accurate reference. If not, reselect it, or try recreating the whole thing from scratch with at new reference.

Andrée Starå

Hi @Cindy Bowker,

Have you checked the Activity Log for information that might help you restore or see how it was working before?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Cindy Bowker

Thanks Andre didn't even think of that.

Cindy

Andrée Starå

@Cindy Bowker

Happy to help!

Easy to miss!

Let me know how it goes!

Cindy Bowker

So that didn't work, I did check the activity log and went back to where it was working but I am still getting the #NO Match error.

I have even tried deleting the reference sheet and creating a new one with the same information. I think that my error is when I am importing the information into the reference sheet from excel.

Any suggestions?

Thanks Cindy

Andrée Starå

@Cindy Bowker

Start with checking the values and if they are interpreted as numbers or text. If they don't match it won't work.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.