VLOOKUP equivalent -- #NO MATCH error

kolfinna

Hello! I have a formula I'm using across several sheets referring to a source table. On 9/10 sheets, the formula works just fine. However, on one the exact same formula yields a #NO MATCH error. I've double-checked my references and everything looks good -- e.g., the match criteria does indeed exist where it should.

Any ideas? I'm at a loss.

Thanks!

Andrée Starå

Hi Kolfinna,

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!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

kolfinna

Hey there!

Went through all the steps to get screenshots and triple-checked my reference table...only to discover I had selected more columns in that sheet than on all the others.

Mistakes were made.

Thanks anyway!

Andrée Starå

Glad you found the issue and 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!