Iferror(vlookup) not pulling all data from a cell.

I am using the Iferror(vlookup) function to track my teams inspections. Recently, I changed the form to have multiple locations, and since then the iferror(vlookup) is not pulling every locations date from the data set. Picture 1 is an example that pulls the data properly, picture 2 does not pull the data, and picture 3 shows the data set it is pulling from. I have tried switching the match type to false and still no change. I copy pasted the values in the data set sheet to ensure spelling is accurate as well.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try an INDEX/COLLECT/HAS instead.

=INDEX(COLLECT({Date Column}, {Location Column}, HAS(@cell, Location@row)), 1)

All comments

Paul Newcome

Try an INDEX/COLLECT/HAS instead.

=INDEX(COLLECT({Date Column}, {Location Column}, HAS(@cell, Location@row)), 1)

Peter Black

That fixed it! Thank you so much, Paul. Had a few syntax issues but got it working perfectly.

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.