Ugh....need help with a cross sheet index/match formula

I have a drop down column titled "SITE", when a SITE is selected, I need the Terminal ID# column to auto populate from another DATABASE sheet for which the SITE column is exactly the same type and title.

=INDEX({SITE Database Range 1}, MATCH([Terminal ID]@row, {SITE Database Range 2}, 0))

Get an UNPARSEABLE error........

Find more posts tagged with

Accepted answers

All comments

It looks like you might have your ranges swapped around. 🙂

An INDEX(MATCH works like this:

=INDEX({Column with value to return}, MATCH([matching value]@row, {Column with matching value}, 0))

So in your case, something like:

=INDEX({SITE Database Terminal ID}, MATCH(SITE@row, {SITE Database Site Column}, 0))

The names of your ranges may be different, but those are the columns it should be pointing to, does that make sense? See: Formula combinations for cross sheet references

If this still hasn't helped, it would be useful to see screen captures of both sheets, but please block out sensitive data.

Cheers,

Genevieve

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.