Help with a VLOOKUP using an auto numbering column

Connie Cochran

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??

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

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!