Lookup and Return a a the Unique Values

tamiz.vedachalam

I have requirement to review the TYPE and return the Food value in unique list

The outcome should like this

written a formula like this like this

=IFERROR(INDEX({Range of "Type"}, MATCH($[Food], {Range of Food}, 0)), "No Match")

the outcome is coming like this. Only the 1st row is appearing and not the others

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You will need to insert a text/number column (called "Number" in this example) and manually enter the numbers starting with 1 and going through however many you anticipate plus a recommended buffer in case there are more than anticipated.

Then you would use

=IFERROR(INDEX(COLLECT({Range of Food}, {Range of "Type"}, @cell = "Food"), Number@row), "")

All comments

Paul Newcome

Then you would use

=IFERROR(INDEX(COLLECT({Range of Food}, {Range of "Type"}, @cell = "Food"), Number@row), "")

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.