Auto Generated Number Referencing

Auto Generated Number Referencing

Hi,

I noticed when using Index match on auto generated numbers something weird happens. On sheet A I use Index({desired result Sheet B}, match(sheet A @row, {search Criteria Sheet B},0),1) where Sheet A @Row is an auto generated number and search criteria sheet B is a text/number input. I found you have to use Index({desired result Sheet B}, match(Value(sheet A @row), {search Criteria Sheet B},0),1). This took some time to figure out but works nicely.

Now I have run into the issue where I am on Sheet B trying to reference sheet A but cannot VALUE reference a whole column ie(Index({desired result Sheet A}, match(sheet B @row, VALUE({search Criteria Sheet A}),0),1). Does anyone know a work around or has also run into this? For some reason I think auto generated numbers aren't coming in as number values.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Amanda Berta

    That sounds strange!

    I use that method all the time in my client solutions. (Auto-number matched to a manual number)

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • edited 05/26/20

    hi @Andrée Starå

    I ended up using =INDEX({Source Range 1}, MATCH(UPPER([Primary Column]@row), {Source Range 2}, 0)). There was a " ' " showing up when I copied the auto generated number which was causing the NO MATCH.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Amanda Berta

    Excellent!

    Glad you got it working!

    Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.