Help with a VLOOKUP using an auto numbering column

I could really use some help. I am trying to use a VLOOKUP formula with an auto numbering column. I tried with and without a trim function but stil having issues.

Receives an #unparseable error - =IFERROR(VLOOKUP(TRIM([Event_ID]@row), {Onsite Feedback Form Range 3}, 4, false), "")

Doesn't return any information - =IFERROR(VLOOKUP([Event_ID]@row, {Onsite Feedback Form Range 4}, 4, false), "")

Help??

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Connie Cochran

Try wrapping a VALUE function around the row reference to ensure the number is being seen as numerical, like this:

=IFERROR(VLOOKUP(VALUE([Event_ID]@row), {Onsite Feedback Form Range 4}, 4, false), "")

Let us know if that worked!

Cheers,

Genevieve

All comments

Andrée Starå

Hi @Connie Cochran

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Connie Cochran

Thank you for your help. This is all dummy data. When I changed the auto number to a regular field and typed in the number it worked but I really need it to work with the auto number. I don't have any special characters in the auto numbering.

Sheet 1

Sheet 2

Genevieve P.

Hi @Connie Cochran

Try wrapping a VALUE function around the row reference to ensure the number is being seen as numerical, like this:

=IFERROR(VLOOKUP(VALUE([Event_ID]@row), {Onsite Feedback Form Range 4}, 4, false), "")

Let us know if that worked!

Cheers,

Genevieve

Connie Cochran

It worked!!! Thank you so much!

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.