VLOOKUP # No Match error

kolfinna

Hey, all. I've done some reading on the above error and haven't quite found an answer that fits my conundrum--or at least, not that I can tell. I may have missed something. Anyway:

Context: I am coordinating a migration over the course of several weeks including hundreds of systems and dozens of people. Each team has set specific weeks/days they will be available to assist with the migration.

Goal: If the migration schedule for any particular system changes, the staffing should automatically update based on the new Start Date.

My first thought was to use [Start]@row as my index to lookup on another sheet {VLOOKUP_TABLE}. However, I keep getting a #No Match error and I'm curious if it's because the Start Date column is in the Date format, and the primary column (what it should match against) for any new sheet must be text/number.

a) Is there a better way to do this?

b) What am I missing?

My current formula looks like this: =VLOOKUP(Start@row, {VLOOKUP_TABLE}, 2, false) --> wondering if I've got the syntax wrong as well.

Thoughts? Thanks!

Paul Newcome

Syntax is good. Try moving one of the columns to the left of the Primary Column, changing it to a date type, then entering your dates into that and using it instead of the Primary Column.

Paul Newcome

Syntax is good. Try moving one of the columns to the left of the Primary Column, changing it to a date type, then entering your dates into that and using it instead of the Primary Column.

kolfinna

Perfect. Thanks so much! Don't know why it hadn't occurred to me that I could insert a column to the left of the primary. /facepalm

:)

Paul Newcome

Haha. No worries. Happy to help! 👍️