Vlookup formula help
Hi,
I am doing a VLOOKUP in which the formula looks up a list of holiday dates listed in a range from a second sheet. If matching, it is to display the second column which identifies the type of holiday (note, in the formula below I have "false" I also tried "true"). The columns sources are both type: date.
the formula:
=VLOOKUP(Calendar@row, {Holidays Range 1}, 2, false)
Source sheet
Holiday sheet:
I'm expecting for the row that has value "08/20/21" to result with "IDC Holiday", instead I have "NO MATCH".
Best Answer
-
Some times it helps to ask the question so that you can figure out what the problem is. My formula is correct. The issue is the source sheet was NOT "date" type like I had thought it was. When I changed the column to "date" it works as advertised.
Answers
-
Some times it helps to ask the question so that you can figure out what the problem is. My formula is correct. The issue is the source sheet was NOT "date" type like I had thought it was. When I changed the column to "date" it works as advertised.
-
I'm glad you figured it out! Thanks for sharing your solution.
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.8K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!