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".

Find more posts tagged with

Formulas

Accepted answers

Glenn Butler

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.

All comments

Glenn Butler

Genevieve P.

Hi @Glenn Butler

I'm glad you figured it out! Thanks for sharing your solution.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.