VLOOKUP # No Match error
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!
Best Answer
-
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.
Answers
-
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.
-
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
:)
-
Haha. No worries. Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!